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:
- Employees:SSN,
- Plane:reg_no
- Test:FAA_No
- Model: model_no
Candidate Keys:
- Employees:SSN,
- Plane:reg_no
- Test:FAA_No
- 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:
- Medical exam in relationship takes annually
- plane in relationship type
- traffjc controller in IS A
- technician in IS A
- Employee in IS A
Constrains:
- Traffic controllers in IS A
- technician in Is A
- employee in IS A
- medical exam in takes annually
- plane in type