2. Turn the E-R diagram into tables (relational model schema). Indicate primary and candidate keys and foreign keys. Give the SQL statements to create the corresponding relations in a relational DBMS
Primary Key:
  1. Employees:SSN, 
  2. Plane:reg_no
  3. Test:FAA_No
  4. Model: model_no
Candidate Keys: 
  1. Employees:SSN, 
  2. Plane:reg_no
  3. Test:FAA_No
  4. Model: model_no
Weak Entitites:
1.medical exam is a weak entity in relationship takes annually where strong entity is traffic controller
Partial Keys:
medical exam has no partial keys
Total Participation:
  1. Medical exam in relationship takes annually
  2. plane in relationship type
  3. traffjc controller in IS A
  4. technician in IS A
  5. Employee in IS A
Constrains:
  1. Traffic controllers in IS A
  2. technician in Is A
  3. employee in IS A
  4. medical exam in takes annually
  5. plane in type