### This is the data  one of the example databases used in "Fundamentals
### of Database Systems", Elmasri and Navathe, Benjamin Cummings.
### Tim Finin, finin@Umbc.edu

DELETE FROM project\g
INSERT INTO project VALUES ('ProductX', '1', 'Bellaire',  '5') \g
INSERT INTO project VALUES ('ProductY', '2', 'Sugarland', '5') \g
INSERT INTO project VALUES ('ProductZ', '3', 'Houston', '5') \g
INSERT INTO project VALUES ('Computerization', '10', 'Stafford', '4') \g
INSERT INTO project VALUES ('Reorganization', '20', 'Houston',  '1') \g
INSERT INTO project VALUES ('Newbenefits', '30',  'Stafford', '4') \g


DELETE FROM dept_locations \g
INSERT INTO dept_locations VALUES ('1', 'Houston') \g
INSERT INTO dept_locations VALUES ('4', 'Stafford') \g
INSERT INTO dept_locations VALUES ('5', 'Bellaire') \g
INSERT INTO dept_locations VALUES ('5', 'Sugarland') \g
INSERT INTO dept_locations VALUES ('5', 'Houston') \g

DELETE FROM employee \g
INSERT INTO employee VALUES ('John', 'B', 'Smith',
        '123456789', '09-Jan-55', 'Houston,TX', 'M', 30000, '333445555', '5') \g
INSERT INTO employee VALUES ('Frank', 'T', 'Wong',
        '333445555', '08-DEC-45', 'Houston,TX', 'M', 40000, '888665555', '5') \g
INSERT INTO employee VALUES ('Alicia', 'J', 'Zelaya',
        '999887777', '19-JUL-58', 'Spring,TX', 'F', 25000, '987654321', '4') \g
INSERT INTO employee VALUES ('Jennifer', 'S', 'Wallace',
        '987654321', '20-JUN-31', 'Bellaire,TX', 'F', 43000, '888665555', '4') \g
INSERT INTO employee VALUES ('Ramesh', 'K', 'Narayan',
        '666884444', '15-SEP-52', 'Humble,TX', 'M', 38000, '333445555', '5') \g
INSERT INTO employee VALUES ('Joyce', 'A', 'English',
        '453453453', '31-JUL-62', 'Houston, TX', 'F', 25000, '333445555', '5') \g
INSERT INTO employee VALUES ('Ahmad', 'V', 'Jabbar',
        '987987987', '29-MAR-59', 'Houston,TX', 'M', 25000, '987654321', '4') \g
INSERT INTO employee VALUES ('James', 'E', 'Borg',
        '888665555', '10-NOV-27', 'Houston,TX', 'M', 55000, null, '1') \g

DELETE FROM department \g
INSERT INTO department VALUES ('Reserch', '5', '333445555', '22-MAY-78') \g
INSERT INTO department VALUES ('Administration', '4', '987654321', '01-JAN-85') \g
INSERT INTO department VALUES ('Headquarters', '1', '888665555', '19-JUN-71') \g

DELETE from dependent \g
INSERT INTO dependent VALUES ('333445555','Alice','F','05-APR-76','Daughter') \g
INSERT INTO dependent VALUES ('333445555','Theodore','M','25-OCT-73','Son') \g
INSERT INTO dependent VALUES ('333445555','Joy','F','03-MAY-48','Spouse') \g
INSERT INTO dependent VALUES ('987654321','Abner','M','29-FEB-32','Spouse') \g
INSERT INTO dependent VALUES ('123456789','Michael','M','01-JAN-78','Son') \g
INSERT INTO dependent VALUES ('123456789','Alice','F', '31-DEC-78','Daughter') \g
INSERT INTO dependent VALUES ('123456789','Elizabeth','F','05-MAY-57','Spouse') \g

DELETE FROM works_on \g
INSERT INTO works_on VALUES ('123456789', '1', 32.5) \g
INSERT INTO works_on VALUES ('123456789', '2', 7.5) \g
INSERT INTO works_on VALUES ('666884444', '3', 40.0) \g
INSERT INTO works_on VALUES ('453453453', '1', 20.0) \g
INSERT INTO works_on VALUES ('453453453', '2', 20.0) \g
INSERT INTO works_on VALUES ('333445555', '2', 10.0) \g
INSERT INTO works_on VALUES ('333445555', '3', 10.0) \g
INSERT INTO works_on VALUES ('333445555', '10', 10.0) \g
INSERT INTO works_on VALUES ('999887777', '30', 30.0) \g
INSERT INTO works_on VALUES ('999887777', '10', 10.0) \g
INSERT INTO works_on VALUES ('987987987', '10', 35.0) \g
INSERT INTO works_on VALUES ('987987987', '30', 5.0) \g
INSERT INTO works_on VALUES ('987654321', '30', 20.0) \g
INSERT INTO works_on VALUES ('987654321', '20', 15.0) \g
INSERT INTO works_on VALUES ('888665555', '20', null) \g