Consider the following database of flight booking system CUSTOMER CustomerlD, Cu

Question

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

Explanation / Answer

A.Joining of three tables:

B. Results Booking join Flight:

C Results Booking join Booking and join with Flight:

D. Joins booking and customers based on comparasion of customer id and results employeeid,date,customerid

CustomerID CustomerName Phone EmployeeID FlightNo Date Price Origon Destination 101 Peter 811-649-322 11 A04 29-09-2017 500 melbourne sydney 101 peter 822-531-989 22 A01 30-09-2017 200 Canberra sydney 202 John 822-674-282 22 A03 29-09-2017 400 Canberra melbourne 303 Miranda 833-674-282 22 A01 30-09-2017 200 Canberra sydney

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---