Car Rental Database AGE 40 CUSTOMER CNAME BLACK GREEN JONES MARTIN SIMON VERNON SSSSSS RESID CITY ERIE CARY HEMET HEMET ERIE CARY BIRTHPLACE TAMPA ERIE TAMPA TAMPA ERIE CARY 60 In table CUSTOMER, CD is the primary key (Customer ID). RIN RENTALS CID MAKE FORD 10 IGM FORD NISSAN DATE OUT PICKUP 10-Oct-1994 CARY 01-Nov-1995 TAMPA 01-Jan-1995 ERIE 07-Jul-1994 TAMPA 01-Jul-1995 CARY 01-Aug-1995 ERIE 01-Aug-1994 CARY 01-Sep-19/95 ERIE 02-Sep-1995 RENO RETURN CARY CARY ERIE TAMPA ERIE ERIE | ERIE CARY RENO 30 30 40 50 GM FORD GM TOYOTA 6 17 18 In the table RENTALS, RTN provides the rental number the primary key), CID is the customer's unique id, PICKUP is the city where the car was picked up, and Return is the city where the car was returned. COST RENTCOST MAKE FORD GM NISSAN TOYOTA VOLVO 30 40 I 30 20 50 RENTCOST shows the base cost of renting a given MAKE for one day. FACTOR CITYADJ CITY CARY ERIE RENO TAMPA If the return city of table RENTALS is the one listed in table CITYADJ, the cost of the rental is multiplied by FACTOR and by DAYS shown in table RENTLENGTH below. RENTLENGTH RTN DAYS 23 73 RENTLENGTH shows the number of days for the rental number (RTN) shown in table RENTALS. In a database used in reality, this table would be merged with the RENTALS table. SELECT CNAME, DATE OUT FROM CUSTOMER INNER JOIN RENTALS ON CUSTOMER.CID = RENTALS.CID WHERE AGE 1) The CNAMEs shown by the execution of this query are