Translate the following ER diagram into a relational schema, ( i.e. show the SQL statements needed to create the relations). If your translation cannot capture any constraints in the ER diagram, explain why

Transcribed Image Text:

model_no name capacity Model weight Test FAA_no name Expert score salary address Type hours phone_num ISA Technician Test_info Employees date score union mem_no exam date Traffic control Plane reg_no model_no name capacity Model weight Test FAA_no name Expert score salary address Type hours phone_num ISA Technician Test_info Employees date score union mem_no exam date Traffic control Plane reg_no

Answer rating: 100% (QA)

1 CREATE TABLE Expert ssn CHAR11 modelno INTEGER PRIMARYKEYssn modelno FOREIGN KEY ssn REFERENCES Te... View the full answer