Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following database of flight booking system CUSTOMER CustomerlD, CustomerName, Phone] PK: CustomerID EMPLOYEE EmployeeID, EmployeeName PK: EmployeelD) FLIGHT {FlightNo, Date, Origin, Destination) PK:
Consider the following database of flight booking system CUSTOMER CustomerlD, CustomerName, Phone] PK: CustomerID EMPLOYEE EmployeeID, EmployeeName PK: EmployeelD) FLIGHT {FlightNo, Date, Origin, Destination) PK: FlightNo, Date) BOOKING {CustomerID, EmployeeID, FlightNo, Date, Price} PK: CustomerlD, EmployeelD, FlightNo, Date) FK: CustomerlDC CUSTOMERCustomerID], [EmployeeID] C EMPLOYEE EmployeeID], [FlightNo, Date C FLIGHT FlightNo, Date FLIGHT CUSTOMER. FlightNoDate Origin Destination Phone 811-649-322 822-531-989 833-674-282 CustomerID CustomerName Sydney Perth 30-09-2017 CanberraS 101 202 303 Peter John Miranda A02 30-09-2017 Sydney A03 29-09-2017 Canberra Melbourne A04 29-09-2017 Melbourne Sydney BOOKING EMPLOYEE EmployeelD EmployeeName CustomerID EmployeeID FlightNo Date Price 101 101 202 303 A04 29-09-2017 500 30-09-2017 200 A0329-09-2017 400 30-09-2017 200 Svlvain ens A01 Consider the following database of flight booking system CUSTOMER CustomerlD, CustomerName, Phone] PK: CustomerID EMPLOYEE EmployeeID, EmployeeName PK: EmployeelD) FLIGHT {FlightNo, Date, Origin, Destination) PK: FlightNo, Date) BOOKING {CustomerID, EmployeeID, FlightNo, Date, Price} PK: CustomerlD, EmployeelD, FlightNo, Date) FK: CustomerlDC CUSTOMERCustomerID], [EmployeeID] C EMPLOYEE EmployeeID], [FlightNo, Date C FLIGHT FlightNo, Date FLIGHT CUSTOMER. FlightNoDate Origin Destination Phone 811-649-322 822-531-989 833-674-282 CustomerID CustomerName Sydney Perth 30-09-2017 CanberraS 101 202 303 Peter John Miranda A02 30-09-2017 Sydney A03 29-09-2017 Canberra Melbourne A04 29-09-2017 Melbourne Sydney BOOKING EMPLOYEE EmployeelD EmployeeName CustomerID EmployeeID FlightNo Date Price 101 101 202 303 A04 29-09-2017 500 30-09-2017 200 A0329-09-2017 400 30-09-2017 200 Svlvain ens A01
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started