Answered step by step
Verified Expert Solution
Link Copied!

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:

image text in transcribedimage text in transcribed

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

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_2

Step: 3

blur-text-image_3

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

MySQL/PHP Database Applications

Authors: Brad Bulger, Jay Greenspan, David Wall

2nd Edition

0764549634, 9780764549632

More Books

Students also viewed these Databases questions

Question

107 MA ammeter 56 resistor ? V voltmeter

Answered: 1 week ago

Question

Generally If Drug A is an inducer of Drug B , Drug B levels will

Answered: 1 week ago