The University Of Programming C

Tuesday, 25 October 2016

Employee and Department tables in oracle - emp and dept table queries in sql


 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)





.