Question: SELECT CID, CNAME FROM CUSTOMER WHERE EXISTS (SELECT CID FROM RENTALS WHERE CUSTOMER.CID = RENTALS.CID AND PICKUP = 'CARY') The execution of this query lists

SELECT CID, CNAME FROM CUSTOMER WHERE EXISTS

SELECT CID, CNAME FROM CUSTOMER WHERE EXISTS (SELECT CID FROM RENTALS WHERE CUSTOMER.CID = RENTALS.CID AND PICKUP = 'CARY') The execution of this query lists the following CNAMES: = = BLACK BLACK, JONES, MARTIN BLACK, GREEN, JONES, MARTIN, SIMON BLACK, GREEN, JONES, MARTIN, SIMON, VERNON Car Rental Database CUSTOMER CID CNAME 10 BLACK 20 GREEN 30 JONES 40 MARTIN 50 SIMON 60 VERNON AGE 40 25 30 35 22 60 RESID CITY ERIE CARY HEMET HEMET ERIE CARY BIRTHPLACE TAMPA ERIE TAMPA TAMPA ERIE CARY In table CUSTOMER, CID is the primary key (Customer ID). RENTALS CID MAKE 10 FORD 10 GM 10 FORD 20 NISSAN 30 FORD 30 GM 40 FORD 50 GM 70 TOYOTA 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 RTN 1 2 13 14 15 16 17 8 19 In the table RENTALS, RIN 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. RENTCOST MAKE FORD GM NISSAN TOYOTA VOLVO COST 30 40 30 20 50 RENTCOST shows the base cost of renting a given MAKE for one day. CITYADJ CITY CARY ERIE RENO TAMPA FACTOR 1 1.1 0.9 0.8 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 RIN 1 2 3 4 4 5 6 7 8 DAYS 1 3 2 2 4 2 3 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

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 General Management Questions!

CUSTOMER In table CUSTOMER, CID is the primary key (Customer ID). RENTALS In the table RENTALS, RTN provides the rental number (the primary key), CID is the customer's unique id, PICKUP is the city...

Use the following tables (with partial data shown) for a car rental database to answer questions 20-25: CUSTOMER In table CUSTOMER, CID is the primary key (Customer ID). RENTALS In the table RENTALS,...

14. A consistent and well-designed database is _____________________. A. One in which all tables have foreign keys B. One in which all tables are de-normalized C. One in which all data integrity...

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...

Use the following tables (with partial data shown) for a car rental database to answer questions 20-25: SEE QUESTIONS BELOW. CUSTOMER CID CNAME AGE RESID_CITY BIRTHPLACE 10 BLACK 40 ERIE TAMPA 20...

SELECT DISTINCT CNAME FROM CUSTOMER WHERE CID IN (SELECT CID FROM RENTALS WHERE RETURN IN (SELECT BIRTHPLACE FROM CUSTOMER)) What is the meaning of this query? a.List customers whose rental was...

2. Create an index: Show the execution time of the query before create index select current_timestamp from dual; select cid from orders; select current_timestamp from dual; Create an index on orders...

In this lab, you will be working with the following tables in SQL Server. To create and populate these tables in SQL Server, run the queries that are listed below these tables. CUSTOMER CID CName Age...

Write and execute a single query that will display all of the information in the Customer, Rentals, and Rentcost tables in a single resultset. Be sure to display each field only once in your output....

Describe the internal and external environments that drive organizational change.

Boeken testified that he read the Surgeon Generals warning about smoking in the 1960s, so how can he argue fraud?

is the process of determining the monetary amounts at which the elements of the financial statements are to be recognized and carried. Comparability Understandability Relevance Measurement

I need assistance trying to answer this questions: What wider lessons can be drawn from the way the project has progressed thus far (e.g., how to overcome budget over-runs, and...