Please use the values below to create an insert statement for this table using mysql server

CREATE TABLE DEPARTMENT( DNUMBER NUMERIC(2) NOT NULL, DNAME VARCHAR(50) NOT NULL, MGRSSN NUMERIC(9)NOT NULL, MGRSTARTDATE DATE NOT NULL, CONSTRAINT DEPT_DNUM_PK PRIMARY KEY (DNUMBER));

CREATE TABLE EMPLOYEE( SSN NUMERIC (9) NOT NULL, FNAME VARCHAR(25) NOT NULL, MINIT VARCHAR(1), LNAME VARCHAR(25) NOT NULL, BDATE DATE NOT NULL, ADDRESS VARCHAR(150) NOT NULL, SEX VARCHAR(1) NOT NULL, SALARY FLOAT, SUPERSSN NUMERIC(9), DNO NUMERIC(2) NOT NULL, CONSTRAINT EMP_SSN_PK PRIMARY KEY(SSN), CONSTRAINT EMP_DNO_FK FOREIGN KEY (DNO) REFERENCES DEPARTMENT(DNUMBER));

CREATE TABLE DEPENDENT( ESSN NUMBER(9) NOT NULL, DEPENDENT_NAME VARCHAR(50) NOT NULL, SEX VARCHAR(1) NOT NULL, BDATE DATE NOT NULL, RELATIONSHIP VARCHAR(15) NOT NULL, CONSTRAINT DEP_ESSN_NAME_PK PRIMARY KEY(ESSN, DEPENDENT_NAME), CONSTRAINT DEP_ESSN_FK FOREIGN KEY (ESSN) REFERENCES EMPLOYEE(SSN));

CREATE TABLE DEPT_LOCATIONS( DNUMBER NUMBER(2) NOT NULL, DLOCATION VARCHAR(50) NOT NULL, CONSTRAINT DEPTLOC_DNUM_DLOC_PK PRIMARY KEY(DNUMBER, DLOCATION), CONSTRAINT DEPTLOC_DNUM_FK FOREIGN KEY (DNUMBER) REFERENCES DEPARTMENT(DNUMBER));

CREATE TABLE PROJECT( PNUMBER NUMBER(3) NOT NULL, PNAME VARCHAR(25) NOT NULL, PLOCATION VARCHAR(50), DNUM NUMBER(2) NOT NULL, CONSTRAINT PROJ_PNUM_PK PRIMARY KEY (PNUMBER) , CONSTRAINT PROJ_DNUM_FK FOREIGN KEY (DNUM) REFERENCES DEPARTMENT(DNUMBER));

CREATE TABLE WORKS_ON( ESSN NUMBER(9) NOT NULL, PNO NUMBER(3) NOT NULL, DNUM FLOAT, CONSTRAINT WRK_ESSN_PNO_PK PRIMARY KEY (ESSN, PNO), CONSTRAINT WRK_ESSN_FK FOREIGN KEY (ESSN) REFERENCES EMPLOYEE(SSN), CONSTRAINT WRK_PNO_FK FOREIGN KEY (PNO) REFERENCES PROJECT(PNUMBER));

DROP INDEX DEPTLOC_DNUM_IDX; DROP INDEX PROJ_DNUM_IDX; DROP INDEX EMP_DNO_IDX; DROP INDEX DEP_ESSN_IDX; DROP INDEX WRK_ESSN_IDX; DROP INDEX WRK_PNO_IDX;

CREATE INDEX DEPTLOC_DNUM_IDX ON DEPT_LOCATIONS(DNUMBER); CREATE INDEX PROJ_DNUM_IDX ON PROJECT(DNUM); CREATE INDEX EMP_DNO_IDX ON EMPLOYEE(DNO); CREATE INDEX DEP_ESSN_IDX ON DEPENDENT(ESSN); CREATE INDEX WRK_ESSN_IDX ON WORKS_ON(ESSN); CREATE INDEX WRK_PNO_IDX ON WORKS_ON(PNO);

grant select on DEPARTMENT to public; grant select on EMPLOYEE to public; grant select on DEPENDENT to public; grant select on DEPT_LOCATIONS to public; grant select on PROJECT to public; grant select on WORKS_ON to public;

Employee FNAME MINITLNAME SSN BDATE ADDRESS SEX John B Smith 123456789 9-Jan-55 731 Fondren, Houston, TX M Franklin T Wong 333445555 8-Dec-45 638 Voss, Houston, TX | Alicia J Zelaya 999887777 19-Jul-58 3321 Castle, Spring, TX F Jennifer S Wallace 987654321 20-Jun-31 231 Berry, Bellaire, TX F Ramesh K Narayan 666884444 15-Aug-52 975 Fire Oak, Humble, TX M Joyce A English 453453453 31-Jul-62 5631 Rice, Houston, TX F Ahmad V Jabbar 987987987 29-Mar-59 980 Dallas, Houston, TX M James E Borg 888665555 10-Nov-27 450 Stone, Houston, TX M SALARY SUPERSSN DNO 30000 333445555 5 40000 888665555 5 25000 987654321 4 43000 888665555 4 38000 333445555 5 25000 333445555 5 25000 987654321 4 55000 1 Department Location DNUMBEDLOCATION 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston Department DNAME research administration headquarters DNUMBEFMGRSSN MGRSTARTDATE 5 333445555 22-May-78 4 987987987 1-Jan-85 1 888665555 19-Jun-71 Project PNAME ProductX ProductY Productz Computerization Reorganization Newbenefits NNWN PLOCATIONUM Bellaire Sugarland Houston Stafford Houston Stafford PNUMBER 5 5 5 4 1 4 1 2 3 10 20 30 - 4 works-on ESSN PNO HOURS 123456789 1 32.5 123456789 7.5 666884444 40 453453453 20 453453453 201 333445555 10 333445555 3 10 333445555 10 10 333445555 20 10 999887777 30 999887777 10 10 987987987 10 35 987987987 30 5 987654321 30 20 987654321 20 15 888665555 20 30 Employee Dependent ESSN DEPENDENT_NAME 333445555 Alice 333445555 Theodore 33344555 Joy 987654321 Abner 123456789 Michael 123456789 Alice 123456789 Elizabeth SEX F M F M M BDATE RELATIONSHIP 5-Apr-76 DAUGHTER 25-Oct-73 SON 3-May-48 SPOUSE 29-Feb-32 SPOUSE 1-Jan-78 SON 31-Dec-78 DAUGHTER 5-May-57 SPOUSE TITI 3 Employee FNAME MINITLNAME SSN BDATE ADDRESS SEX John B Smith 123456789 9-Jan-55 731 Fondren, Houston, TX M Franklin T Wong 333445555 8-Dec-45 638 Voss, Houston, TX | Alicia J Zelaya 999887777 19-Jul-58 3321 Castle, Spring, TX F Jennifer S Wallace 987654321 20-Jun-31 231 Berry, Bellaire, TX F Ramesh K Narayan 666884444 15-Aug-52 975 Fire Oak, Humble, TX M Joyce A English 453453453 31-Jul-62 5631 Rice, Houston, TX F Ahmad V Jabbar 987987987 29-Mar-59 980 Dallas, Houston, TX M James E Borg 888665555 10-Nov-27 450 Stone, Houston, TX M SALARY SUPERSSN DNO 30000 333445555 5 40000 888665555 5 25000 987654321 4 43000 888665555 4 38000 333445555 5 25000 333445555 5 25000 987654321 4 55000 1 Department Location DNUMBEDLOCATION 1 Houston 4 Stafford 5 Bellaire 5 Sugarland 5 Houston Department DNAME research administration headquarters DNUMBEFMGRSSN MGRSTARTDATE 5 333445555 22-May-78 4 987987987 1-Jan-85 1 888665555 19-Jun-71 Project PNAME ProductX ProductY Productz Computerization Reorganization Newbenefits NNWN PLOCATIONUM Bellaire Sugarland Houston Stafford Houston Stafford PNUMBER 5 5 5 4 1 4 1 2 3 10 20 30 - 4 works-on ESSN PNO HOURS 123456789 1 32.5 123456789 7.5 666884444 40 453453453 20 453453453 201 333445555 10 333445555 3 10 333445555 10 10 333445555 20 10 999887777 30 999887777 10 10 987987987 10 35 987987987 30 5 987654321 30 20 987654321 20 15 888665555 20 30 Employee Dependent ESSN DEPENDENT_NAME 333445555 Alice 333445555 Theodore 33344555 Joy 987654321 Abner 123456789 Michael 123456789 Alice 123456789 Elizabeth SEX F M F M M BDATE RELATIONSHIP 5-Apr-76 DAUGHTER 25-Oct-73 SON 3-May-48 SPOUSE 29-Feb-32 SPOUSE 1-Jan-78 SON 31-Dec-78 DAUGHTER 5-May-57 SPOUSE TITI 3