Convert the diagram into a set of relational tables. The tables must be in 3NF. All referential integrity and functional dependencies must be indicated accurately in EITHER of the following 2 ways:...

Convert the diagram into a set of relational tables. The tables must be in 3NF. All referential integrity and functional dependencies must be indicated accurately in EITHER of the following 2 ways:

• Draw lines
  for referential integrity
  and for functional dependencies as belows.

1. Show referential integrity as follows:

Supplier(S#, Sname, City, Status);

Part(P#, Pname, Color, Weight, City);

SP(S#, P#, QTY)

Foreign key (S#) References Supplier,

Foreign key (P#) References Part;

2. Show functional dependencies as follows: B → C CD → E

Extracted text: Manager Manager_ID Manager_FName Manager_LName Manager_Phone# Manager_Date_Joined Manages Employees Courts Employee_ID Employee_FName Employee_LName Employee_Phone# Employee_Date_Joined Court_# Referee Assigned includes Shifts Equipment Shift_Date Shift_Time Equipment_Num Equipment_Type Customers Customer_ID PK Name Reservations Customer_FName Customer_LName Customer_Phone# Customer_Date_Joined Reserve_Date Reserve_Time Create-