insert into department values 
 ('Research',5,333445555,'22-MAY-1988');
insert into department values 
 ('Administration',4,987654321,'01-JAN-1995');
insert into department values 
 ('Headquarters',1,888665555,'19-JUN-1981');


insert into employee values 
 ('John','Smith',123456789,'09-JAN-1965','731 Fondren, Houston TX','M',30000,333445555,5);
insert into employee values 
 ('Franklin','Wong',333445555,'08-DEC-1965','638 Voss, Houston TX','M',40000,888665555,5);
insert into employee values 
 ('Alicia','Zelaya',999887777,'19-JAN-1968','3321 Castle, Spring TX','F',25000,987654321,4);
insert into employee values 
 ('Jennifer','Wallace',987654321,'20-JUN-1941','291 Berry, Bellaire TX','F',43000,888665555,4);
insert into employee values 
 ('Ramesh','Narayan',666884444,'15-SEP-1962','975 Fire Oak, Humble TX','M',38000,333445555,5);
insert into employee values 
 ('Joyce','English',453453453,'31-Jul-1972','5631 Rice, Houston TX','F',25000,333445555,5);
insert into employee values 
 ('Ahmad','Jabbar',987987987,'29-MAR-1969','980 Dallas, Houston TX','M',25000,987654321,4);
insert into employee values 
 ('James','Borg',888665555,'10-NOV-1937','450 Stone, Houston TX','M',55000,null,1);


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);


insert into dependent values 
 (333445555,'Alice','F','04-APR-1986','Daughter');
insert into dependent values 
 (333445555,'Theodore','M','25-OCT-1983','Son');
insert into dependent values 
 (333445555,'Joy','F','03-MAY-1958','Spouse');
insert into dependent values 
 (987654321,'Abner','M','28-FEB-1942','Spouse');
insert into dependent values 
 (123456789,'Michael','M','04-JAN-1988','Son');
insert into dependent values 
 (123456789,'Alice','F','30-DEC-1988','Daughter');
insert into dependent values 
 (123456789,'Elizabeth','F','05-MAY-1967','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');


set constraints depemp immediate; 


set constraints empemp immediate;