Figuer:
CUSTOMER (Primary Key = CID)
CNAME Is NOT NULL

question 40

Multiple Choice

Figuer:
CUSTOMER (primary key = CID)
CNAME is NOT NULL $$\begin{array} { | l | l | l | l | l | } \hline \text { CID } & \text { CNAME } & \text { AGE } & \text { RESID\_CITY } & \text { Cregion } \\\hline 10 & \text { BLACK } & 40 & \text { SD } & \text { SD } \\\hline 20 & \text { GREEN } & 25 & \text { SD } & \text { SD } \\\hline 30 & \text { JONES } & 30 & \text { La Mesa } & \text { SD } \\\hline 40 & \text { MARTIN } & 35 & \text { LA } & \text { LA } \\\hline 50 & \text { SIMON } & 22 & \text { Pomona } & \text { LA } \\\hline 60 & \text { VERNON } & 60 & \text { Poway } & \text { SD } \\\hline\end{array}$$ RENTALS (primary key = RTN)
CID is a foreign key referencing CUSTOMER
CID is NOT NULL
MAKE is NOT NULL
MAKE is a foreign key referencing RENTCOST $$\begin{array} { | l | l | l | l | l | l | } \hline \text { CID } & \text { MAKE } & \text { DATE\_OUT } & \text { PICKUP } & \text { RETURN } & \text { RTN } \\\hline 10 & \text { FORD } & 10 - \text { Oct-00 } & \text { SD } & \text { SD } & 1 \\\hline 10 & \text { GM } & 01 - \text {-Jan-01 } & \text { SD } & \text { LA } & 2 \\\hline 10 & \text { FORD } & 01 - \text { Feb-01 } & \text { LA } & \text { SD } & 3 \\\hline 20 & \text { NISSAN } & 07 - J u l - 00 & \text { SD } & & 4 \\\hline 30 & \text { FORD } & 01 - J u l - 00 & \text { SD } & \text { SD } & 5 \\\hline 30 & \text { GM } & 01 - \text {-Dec-00 } & \text { SD } & \text { SD } & 6 \\\hline 40 & \text { FORD } & 01 - \text { Aug-00 } & \text { LA } & \text { LA } & 7 \\\hline 50 & \text { GM } & 01 - \text { Sep-00 } & \text { LA } & \text { SD } & 8 \\\hline 60 & \text { NISSAN } & 02 \text {-Jan-01 } & \text { SD } & \text { LA } & 9 \\\hline\end{array}$$ RENTCOST
MAKE is the primary key $$\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}$$ (Access) View1:
SELECT RTN, MAKE, PICKUP, RENTALS.CID,
CUSTOMER.CID, CNAME, AGE, Cregion
FROM CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID
(Access) View2:
SELECT RTN, MAKE, PICKUP, RENTALS.CID,
CNAME, AGE, Cregion
FROM CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID
(Access) View3:
SELECT RTN, RENTALS.MAKE, PICKUP, RENTALS.CID,
CNAME, AGE, Cregion, COST
FROM (CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID.
INNER JOIN RENTCOST
ON RENTALS.MAKE = RENTCOST.MAKE
-(Access) Which of the following statements is true?

• A) Data in RENTALS may be updated, using an UPDATE command on View3
• B) Data in CUSTOMER may be updated, using an UPDATE command on View3
• C) Data in RENTCOST may be updated, using an UPDATE command on View3
• D) All of the above

---

Definitions:

P(A ∩ B)

The probability of the intersection of events A and B, indicating the likelihood of both events occurring simultaneously.

P(B)

The probability notation representing the likelihood of event B occurring.

Indian Slave Trade

The historical practice of enslavement and trade of indigenous peoples of the Americas, especially prevalent during the European colonization era.

French Colonial Control

The period during which France established and maintained colonies in various parts of the world, notably in Africa, Asia, and the Americas, from the 16th to the 20th century.