CUSTOMER RENTALS In the Table RENTALS, Rtn Provides the Rental Number (The

question 63

Multiple Choice

CUSTOMER
$$\begin{array} { | l | l | l | l | } \hline \text { Cname } & \text { Age } & \text { Resid\_City } & \text { BirthPlace } \\\hline \text { BLACK } & 40 & \text { ERIE } & \text { TAMPA } \\\hline \text { GREEN } & 25 & \text { CARY } & \text { ERIE } \\\hline \text { JONES } & 30 & \text { HEMET } & \text { TAMPA } \\\hline \text { MARTIN } & 35 & \text { HEMET } & \text { TAMPA } \\\hline \text { SIMON } & 22 & \text { ERIE } & \text { ERIE } \\\hline \text { VERNON } & 60 & \text { CARY } & \text { CARY } \\\hline\end{array}$$
RENTALS
$\begin{array}{|l|l|l|l|l|l|}\hline \text { Cname } & \text { Make } & \text { Date\_Out } & \text { Pickup } & \text { Return } & \text { Rtn } \\\hline \text { BLACK } & \text { FORD } & 10-\text { Oct-1994 } & \text { CARY } & \text { CARY } & 1 \\\hline \text { BLACK } & \text { GM } & 01-\text { Nov-1995 } & \text { TAMPA } & \text { CARY } & 2 \\\hline \text { BLACK } & \text { FORD } & 01-J a n-1995 & \text { ERIE } & \text { ERIE } & 3 \\\hline \text { GREEN } & \text { NISSAN } & 07-J u l-1994 & \text { TAMPA } & \text { TAMPA } & 4 \\\hline \text { JONES } & \text { FORD } & 01-J u l-1995 & \text { CARY } & \text { ERIE } & 5 \\\hline \text { JONES } & \text { GM } & 01-A u g-1995 & \text { ERIE } & \text { ERIE } & 6 \\\hline \text { MARTIN } & \text { FORD } & 01-A u g-1994 & \text { CARY } & \text { ERIE } & 7 \\\hline \text { SIMON } & \text { GM } & 01-S e p-1995 & \text { ERIE } & \text { CARY } & 8 \\\hline \text { WARP } & \text { TOYOTA } & 02-S e p-1995 & \text { RENO } & \text { RENO } & 9 \\\hline\end{array}$
In the table RENTALS, Rtn provides the rental number (the primary key., Cname refers to the Cname in Customer, Pickup is the city where the car was picked up, and Return is the city where the car was returned.

RENTCOST
$$\begin{array} { | l | l | } \hline \text { MAKE } & \text { COST } \\\hline \text { FORD } & 30 \\\hline \text { GM } & 40 \\\hline \text { NISSAN } & 30 \\\hline \text { TOYOTA } & 20 \\\hline \text { VOLVO } & 50 \\\hline\end{array}$$
In RENTCOST, COST shows the base cost of renting a given MAKE for one day.

CITYADJ
$$\begin{array} { | l | l | } \hline \text { CITY } & \text { FACTOR } \\\hline \text { CARY } & 1 \\\hline \text { ERIE } & 1.1 \\\hline \text { RENO } & 0.9 \\\hline \text { TAMPA } & 0.8 \\\hline\end{array}$$
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
$$\begin{array} { | l | l | } \hline \text { RTN } & \text { DAYS } \\\hline 1 & 1 \\\hline 2 & 3 \\\hline 3 & 2 \\\hline 4 & 2 \\\hline 5 & 4 \\\hline 6 & 2 \\\hline 7 & 3 \\\hline 8 & 1 \\\hline\end{array}$$
RENTLENGTH shows the number of DAYS for the rental number (RTN) of the table RENTALS (this table exists for the sake of testing SQL. Normally, the data here should be part of table RENTALS.
-The execution of the query SELECT RENTALS.Cname,RENTALS.Make,CUSTOMER.Resid_City,RENTCOST.COST
FROM RENTALS,CUSTOMER,RENTCOST
WHERE RENTALS.Cname = CUSTOMER.Cname
AND RENTALS.Make = RENTCOST.MAKE
Produces the following number of rows:

---

Definitions:

Proactive Interference

When access to newer memories is impaired by older memories.

Retroactive Interference

When access to older memories is impaired by newer memories.

Cryptomnesia

A phenomenon where a person mistakenly believes a memory or idea is new or original when it is actually derived from a forgotten source.

Source Amnesia

A type of amnesia in which someone can remember certain information but is unable to recall where, when, or how they learned that information.