Database Reverse Engineering 3


Red Bold: Primary Key
 

Practice 1

Actor                                                                                                                                                                        

Actor_ID

 

Actor_FName

 

Actor_LName

 

Actor_Rate

 

Actor_Agency

 

 

Movie                                                          

Title_ID

 

Movie_Title

 

Budget

 

Actor_ID

 

 

Practice 2 (Assumption: not 1:M & M:N)

Departrment                                                              Employee                                                                                                                                                

Dept_ID

 

Budget

Dept_name

 

Emp_ID

LName

Dept_ID

 

 

Practice 4

Employee (FK: Supervisor_ID)                                                                               

Emp_ID
Emp_Name
Emp_Address
Supervisor_ID

 
Practice 3

Employee                                                                        Dependent                                                                                                               

E_ID

 

Lname

Fname

Salary

 

Dept_ID

E_ID

Lname

Fname