ALL foreign key check enabled!

-- populates table data
INSERT INTO `DEPARTMENT` VALUES ('Headquarters', '1', '888665555', '1981-06-19');
INSERT INTO `DEPARTMENT` VALUES ('Research', '5', '333445555', '1988-05-22');
INSERT INTO `DEPARTMENT` VALUES ('Administration', '4', '987654321', '1995-01-01');
INSERT INTO `EMPLOYEE` VALUES ('John', 'B', 'Smith', '123456789', '1965-01-09', '731 Fondren Houston TX', 'M', '30000', '333445555', '5');
INSERT INTO `EMPLOYEE` VALUES ('Ramesh', 'K', 'Narayan', '666884444', '1962-09-16', '975 Fire Oak Humble TX', 'M', '38000', '333445555', '5');
INSERT INTO `EMPLOYEE` VALUES ('Joyce', 'A', 'English', '453453453', '1972-07-31', '5631 Rice Houston TX', 'F', '25000', '333445555', '5');
INSERT INTO `EMPLOYEE` VALUES ('Alicia', 'J', 'Zelaya', '999887777', '1968-07-19', '3321 Castle Spring TX', 'F', '25000', '987654321', '4');
INSERT INTO `EMPLOYEE` VALUES ('Ahmad', 'V', 'Jabbar', '987987987', '1969-03-29', '980 Dallas Houston TX', 'M', '25000', '987654321', '4');
INSERT INTO `DEPENDENT` VALUES ('333445555', 'Alice', 'F', '1986-04-05', 'DAUGHTER');
INSERT INTO `DEPENDENT` VALUES ('333445555', 'Theodore', 'M', '1983-10-25', 'SON');
INSERT INTO `DEPENDENT` VALUES ('333445555', 'Joy', 'F', '1958-05-03', 'SPOUSE');
INSERT INTO `DEPENDENT` VALUES ('987654321', 'Abner', 'M', '1942-02-28', 'SPOUSE');
INSERT INTO `DEPENDENT` VALUES ('123456789', 'Michael', 'M', '1988-01-04', 'SON');
INSERT INTO `DEPENDENT` VALUES ('123456789', 'Alice', 'F', '1988-12-30', 'DAUGHTER');
INSERT INTO `DEPENDENT` VALUES ('123456789', 'Elizabeth', 'F', '1967-05-05', 'SPOUSE');
INSERT INTO `DEPT_LOCATIONS` VALUES ('1', 'Houston');
INSERT INTO `DEPT_LOCATIONS` VALUES ('4', 'Stafford');
INSERT INTO `DEPT_LOCATIONS` VALUES ('5', 'Bellaire');
INSERT INTO `DEPT_LOCATIONS` VALUES ('5', 'Sugarland');
INSERT INTO `DEPT_LOCATIONS` VALUES ('5', 'Houston');
INSERT INTO `PROJECT` VALUES ('ProductX', '1', 'Bellaire', '5');
INSERT INTO `PROJECT` VALUES ('ProductY', '2', 'Sugarland', '5');
INSERT INTO `PROJECT` VALUES ('ProductZ', '3', 'Houston', '5');
INSERT INTO `PROJECT` VALUES ('Computerization', '10', 'Stafford', '4');
INSERT INTO `PROJECT` VALUES ('Reorganization', '20', 'Houston', '1');
INSERT INTO `PROJECT` VALUES ('Newbenefits', '30', 'Stafford', '4');
INSERT INTO `WORKS_ON` VALUES ('123456789', '1', '32.5');
INSERT INTO `WORKS_ON` VALUES ('123456789', '2', '7.5');
INSERT INTO `WORKS_ON` VALUES ('666884444', '3', '40.0');
INSERT INTO `WORKS_ON` VALUES ('453453453', '1', '20.0');
INSERT INTO `WORKS_ON` VALUES ('453453453', '2', '20.0');
INSERT INTO `WORKS_ON` VALUES ('333445555', '2', '10.0');
INSERT INTO `WORKS_ON` VALUES ('333445555', '3', '10.0');
INSERT INTO `WORKS_ON` VALUES ('333445555', '10', '10.0');
INSERT INTO `WORKS_ON` VALUES ('333445555', '20', '10.0');
INSERT INTO `WORKS_ON` VALUES ('999887777', '30', '30.0');
INSERT INTO `WORKS_ON` VALUES ('999887777', '10', '10.0');
INSERT INTO `WORKS_ON` VALUES ('987987987', '10', '35.0');
INSERT INTO `WORKS_ON` VALUES ('987987987', '30', '5.0');
INSERT INTO `WORKS_ON` VALUES ('987654321', '30', '20.0');
INSERT INTO `WORKS_ON` VALUES ('987654321', '20', '15.0');
INSERT INTO `WORKS_ON` VALUES ('888665555', '20', NULL);