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, 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
Get step-by-step solutions from verified subject matter experts
