/* add all the employees, initially without superssn and dno info. */
insert into employee values ('John', 'B', 'Smith', 123456789, '09-JAN-55',
	'731 Fondren, Houston, TX', 'M', 30000, NULL, NULL);

insert into employee values ('Franklin', 'T', 'Wong', 333445555, '08-DEC-45',
	'638 Voss, Houston, TX', 'M', 40000, NULL, NULL);

insert into employee values ('Alicia', 'J', 'Zelaya', 999887777, '19-JUL-58',
	'3321 Castle, Spring, TX', 'F', 25000, NULL, NULL);

insert into employee values ('Jennifer', 'S', 'Wallace', 987654321, '20-JUN-31',
	'291 Berry, Bellaire, TX', 'F', 43000, NULL, NULL);

insert into employee values ('Ramesh', 'D', 'Narayan', 666884444, '15-SEP-52',
	'975 Fire Oak, Humble, TX', 'M', 38000, NULL, NULL);

insert into employee values ('Joyce', 'A', 'English', 453453453, '31-JUL-62',
	'5631 Rice, Houston, TX', 'F', 25000, NULL, NULL);

insert into employee values ('Ahmad', 'V', 'Jabbar', 987987987, '29-MAR-59',
	'980 Dallas, Houston, TX', 'M', 25000, NULL, NULL);

insert into employee values ('James', 'E', 'Borg', 888665555, '10-NOV-27',
	'450 Stone, Houston, TX', 'M', 55000, NULL, NULL);

/* add all departments */
insert into department values ('Research', 5, 333445555, '22-MAY-78');
insert into department values ('Administration', 4, 987654321, '01-JAN-85');
insert into department values ('Headquarters', 1, 888665555, '19-JUN-71');

/* update employees to include superssn, dno info. */
update employee set superssn = 333445555 where ssn = 123456789;
update employee set dno = 5 where ssn = 123456789;

update employee set superssn = 333445555 where ssn = 666884444;
update employee set dno = 5 where ssn = 666884444;

update employee set superssn = 333445555 where ssn = 453453453;
update employee set dno = 5 where ssn = 453453453;

update employee set superssn = 888665555 where ssn = 333445555;
update employee set dno = 5 where ssn = 333445555;

update employee set superssn = 987654321 where ssn = 999887777;
update employee set dno = 4 where ssn = 999887777;

update employee set superssn = 888665555 where ssn = 987654321;
update employee set dno = 4 where ssn = 987654321;

update employee set superssn = 987654321 where ssn = 987987987;
update employee set dno = 4 where ssn = 987987987;

update employee set dno = 1 where ssn = 888665555;

/* add all dept_locations */
insert into dept_locations values (1, 'Houston');
insert into dept_locations values (4, 'Stafford');
insert into dept_locations values (5, 'Houston');
insert into dept_locations values (5, 'Bellaire');
insert into dept_locations values (5, 'Sugarland');

/* add all projects */
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);

/* add all works_on tuples */
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);
insert into works_on values (453453453, 1, 20);
insert into works_on values (453453453, 2, 20);
insert into works_on values (333445555, 2, 10);
insert into works_on values (333445555, 3, 10);
insert into works_on values (333445555, 10, 10);
insert into works_on values (333445555, 20, 10);
insert into works_on values (999887777, 30, 30);
insert into works_on values (999887777, 10, 10);
insert into works_on values (987987987, 10, 35);
insert into works_on values (987987987, 30, 5);
insert into works_on values (987654321, 30, 20);
insert into works_on values (987654321, 20, 15);

/* add all dependents */
insert into dependent values (333445555, 'Alice', 'F', '05-APR-76',
	'DAUGHTER');

insert into dependent values (333445555, 'Theodore', 'M', '25-OCT-73',
	'SON');

insert into dependent values (333445555, 'Joy', 'F', '03-MAY-48',
	'SPOUSE');

insert into dependent values (987654321, 'Abner', 'M', '29-FEB-32',
	'SPOUSE');

insert into dependent values (123456789, 'Michael', 'M', '01-JAN-78',
	'SON');

insert into dependent values (123456789, 'Alice', 'F', '31-DEC-78',
	'DAUGHTER');

insert into dependent values (123456789, 'Elizabeth', 'F', '05-MAY-51',
	'SPOUSE');

