1. Employee(EMP) tables in Oracle.
2. Department(DEPT) tables in Oracle.
3. Works_on tables in Oracle.
4. Department Location(DEPT_LOC) tables in Oracle.
5. Project tables in Oracle.
2. Dependent tables in Oracle.
_________________________________________________________________
Sl#
|
1.Employee
|
Sl#
|
2.Department
|
|||
1
|
FName
|
varchar2(50)
|
1
|
Dname
|
varchar2(50)
|
|
2
|
Minit
|
char(1)
|
2
|
DNumber
|
number(2)
|
|
3
|
LName
|
varchar2(50)
|
3
|
Mgr_ssn
|
number(10)
|
|
4
|
Ssn
|
number(10)
|
4
|
Mgr_start_date
|
Date
|
|
5
|
BDate
|
date
|
||||
6
|
Adress
|
varchar2(100)
|
Sl#
|
4.Dept_Location
|
||
7
|
Sex
|
char(1)
|
1
|
Dnumber
|
number(2)
|
|
8
|
Salary
|
number(8,2)
|
2
|
Dlocation
|
varchar2(50)
|
|
9
|
Supper_ssn
|
number(10)
|
||||
10
|
Dno
|
number(2)
|
Sl#
|
5.Project
|
||
1
|
Pname
|
varchar2(50)
|
||||
Sl#
|
3.Works_On
|
2
|
PNumber
|
number(2)
|
||
1
|
Essn
|
number(10)
|
3
|
PLocation
|
varchar2(50)
|
|
2
|
Pno
|
number(2)
|
4
|
DNum
|
number(2)
|
|
3
|
Hours
|
number(5,2)
|
||||
Sl#
|
6.Dependent
|
|||||
1
|
Essn
|
number(10)
|
||||
3
|
Dependent_Name
|
varchar2(50)
|
||||
4
|
Sex
|
char(1)
|
||||
5
|
BDate
|
date
|
||||
6
|
Relationship
|
varchar2(50)
|
||||
