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:
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:
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 the Assign table:
7369,20
7499,30
7521,30
7566,20
7654,30
7698,30
7782,10
7788,20
7839,\N
7844,30
7876,20
7900,30
7902,20
7934,30