undefined

Only QBE tables required

Exercise 2 (QBE) [15 points] Consider the following table schemas (primary keys are underlined): Drivers (did, dname, gender, age) Reserve (did, cid, day, cost) Cars (cid, cname, model, color, rid) RentalCompany (rid, rname, revenue, rating) IsMember (did, rid, join_time, member_type) Draw Query-By-Example (QBE) tables for the following queries. 1. [3 points) Find the names of drivers and average cost associated with each driver. 2. [2 points) Find the names of cars that have never been rented along with their rental company names and ratings. 3. [2 points] Find the name of the oldest driver who is a member of both company Avis' and company Hertz'. 4. [3 points] Update the member type to `VIP' for those drivers who have been members of company Avis' and have spent more than $1500 in renting (reserving) cars from 'Avis'. 5. [2 points) Find the average age of drivers who have rented the car Mo (cname) from the rental company Avis' and whose member_type is VIP'. 6. [3 points] Find the car model that has been rented most frequently by drivers whose age is greater than 21 and less than 30