A file for One-to-Many Table Administration(DeptAssignEmp.txt): CREATE TABLE department ( deptNo int(2), dName char(10), location char(10), salary decimal(7,2), PRIMARY KEY (deptNo) ) ENGINE=InnoDB; Data for the Department table(dept.csv) 10,ACCOUNTING,NEW YORK,11637.50 20,RESEARCH,DALLAS,14463.75 30,SALES,CHICAGO,12502.00 40,OPERATIONS,BOSTON,.00 CREATE TABLE employee ( empno int(4), ename char(10), job varchar(9), manager int(4), hireDate date, salary decimal(7,2), PRIMARY KEY (empno), ) ENGINE=InnoDB; Data for the Employee table(emp.csv): 7369,SMITH,CLERK,7902,1995-12-17,1064.00 7499,ALLEN,SALESMAN,7698,1996-02-20,2128.00 7521,WARD,SALESMAN,7698,1996-02-22,1662.50 7566,JONES,MANAGER,7839,196-04-02,4000.00 7654,MARTIN,SALESMAN,7698,1996-09-28,1662.50 7698,BLAKE,MANAGER,7839,1996-05-01,4000.00 7782,CLARK,MANAGER,7839,1996-06-09,4000.00 7788,SCOTT,ANALYST,7566,2002-04-19,3990.00 7839,KING,PRESIDENT,\N,17-1980-11-17,1.00 7844,TURNER,SALESMAN,7698,1996-09-08,1995.00 7876,ADAMS,CLERK,7788,2002-05-23,1463.00 7900,JAMES,CLERK,7698,1996-12-03,1263.50 7902,FORD,ANALYST,7566,1996-12-03,3990.00 7934,MILLER,CLERK,7782,1997-01-23,1729.00 Data for assignments(assign.csv): 10,7782 10,7934 20,7369 20,7566 20,7788 20,7876 20,7902 30,7499 30,7521 30,7654 30,7698 30,7844 30,7900