Question: 16. There are three entities below: AIRCRAFT, ASSIGNMENT, AND FLIGHT. Please write down their relationships according to the tables (2 points). Then write down the
16. There are three entities below: AIRCRAFT, ASSIGNMENT, AND FLIGHT. Please write down their relationships according to the tables (2 points). Then write down the related business rules (3 points). Database name: Ch02_Airline Table name: AIRCRAFT Table name: ASSIGNMENT AC_NUM 123U 375G 411H AC_MODEL MD-80 B-737 B-737 FLT_NUM FLT_DATE AC_NUM 101 14-Jan-16 375G 101 15-Jan-16 375G 101 16-Jan-16 411H 101 17-Jan-16 375G 101 18-Jan-16 123U 102 14-Jan-16 375G 102 15-Jan-16 375G 102 16-Jan-16 411H 102 17-Jan-16 375G 102 18-Jan-16 123U Table name: FLIGHT FLT_NUM FLT_ORIGIN FLT_DESTINATION 101 MEM ATL 102 ATL MEM
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
