Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions