Indicate the referential integrity constraints (primary and foreign key relationships) using arrows. Clearly indicate datatype for each attribute.

 

Transcribed Image Text:

Test(FAA_no, name, score) Plane(reg_no, Model_no) Test_info (SSN, FAA_no,plane_reg_no, hours,date, score) Model(Model_no, capacity, weight) Technitian (SSN, union_mem_number, name, phone_no, address, salary) Traffic Controller(SSN, union_mem_number, exam_date) Model_expert(Model_no, SSN) Test(FAA_no, name, score) Plane(reg_no, Model_no) Test_info (SSN, FAA_no,plane_reg_no, hours,date, score) Model(Model_no, capacity, weight) Technitian (SSN, union_mem_number, name, phone_no, address, salary) Traffic Controller(SSN, union_mem_number, exam_date) Model_expert(Model_no, SSN)