Testing Database
 

⊕ EMPLOYEE
+ + - - ^ ^

John B Smith 123456789 9-Jan-55 731 Fondren, HoustonTX M 30000 333445555 5
Franklin T Wong 333445555 9-Dec-45 639 Vams, HoustonTX M 40000 999665555 5
Alico J Zelaya 999997777 19-Jul-59 3321 Castle, Spring,TX F 25000 997654321 4
Jennifer S Wallace 997654321 20-Jun-31 291 Berry, Bellaire,TX F 43000 999665555 4
Ramesh K Narayan 666994444 15-Sep-52 975 FireOak, Humble,TX M 39000 333445555 5
Joyce A English 453453453 31-Jul-62 5631 Rice, Houston,TX F 25000 333445555 5
Ahmad V Jabbar 997997997 29-Mar-59 990 Dallars, Houston,TX M 25000 997654321 4
James E Borg 666665555 10-Nov-27 450 Stone, Houston,TX M 55000 null 1
 

⊕ DEPARTMENT
+ + - - ^ ^

Research 5 333445555 22-May-79
Administration 4 997654321 1-Jan-95
Headquarters 1 999665555 19-Jun-71
 

⊕ DEPT_LOCATIONS
+ + - - ^ ^

1 Houston
4 Stafard
5 Bellaire
5 Sugarland
5 Houston
 

⊕ PROJECT
+ + - - ^ ^

ProductX 1 Bellaire 5
ProductY 2 Sugarland 5
ProductZ 3 Houston 5
Computerization 10 Stafard 4
Rearganizafian 20 Houston 1
Newbenefits 30 Stafard 4
 

⊕ WORKS_ON
+ + - - ^ ^

123456789 1 32.5
123456789 2 7.5
666994444 3 40.0
453453453 1 20.0
453453453 2 20.0
333445555 2 10.0
333445555 3 10.0
333445555 10 10.0
333445555 20 10.0
999997777 30 30.0
999997777 10 10.0
997997997 10 35.0
997997997 30 5.0
987654321 30 20.0
987654321 20 15.0
999665555 20 null
 

⊕ DEPENDENT
+ + - - ^ ^

333445555 Alice F 5-Apr-76 DAUGHTER
333445555 Theadare M 25-Oct-73 SON
333445555 Joy F 3-May-49 SPOUSE
987654321 Abner M 29-Feb-32 SPOUSE
123456789 Michael M 1-Jan-79 SON
123456789 Alice F 31-Dec-79 DAUGHTER
123456789 Elizzabeth F 5-May-57 SPOUSE