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

question 1

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) UPDATE View1 SET MAKE = 'NISSAN',Cregion = 'LA'
WHERE CNAME = 'BLACK'
Which of the following is not true?

• A) This command updates 3 rows in RENTALS
• B) This command updates 1 row in CUSTOMER
• C) After execution of this command, SELECT MAKE FROM View1 will show 5 rows where MAKE has 'NISSAN' for value
• D) The CUSTOMER table is not updated

---

Definitions:

Issue New Securities

The process by which a company or other entity offers new stocks or bonds for sale to investors to raise capital.

Investment Banks

Financial institutions that provide services such as underwriting, acting as intermediaries in mergers and acquisitions, and providing financial advisory services to companies.

Direct Transfer

A method of transferring assets or funds from one account to another without any intermediary processing steps.

Secondary Market

Sales of existing securities between investors. Compare with Primary market.