Question: Consider the following table schemas (primary keys are underlined): - Company(cID, name, location) - Flight(ID , fnumber, departure, arrival, price:integer, number of seats: integer) -

 Consider the following table schemas (primary keys are underlined): - Company(cID,

Consider the following table schemas (primary keys are underlined): - Company(cID, name, location) - Flight(ID , fnumber, departure, arrival, price:integer, number of seats: integer) - Book(bID, cID, fnumber, customerID, seat, date) - Customers(customerID, name, address) Draw Query-by-Example (QBE) tables for the following queries. (a) [3 points] Find the names and addresses of customers who never booked a flight. (b) 3 points ] Find the names of customers who booked flights to Boston and Seattle. (c) [3 points] Insert tuples into a new table CustomerCheck that stores the names and addresses of customers who booked a flight from New York to LA on 04/30/22 and also provides their flight numbers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!