If the Primary Key of a Table Is Clumsy Because

question 102

Multiple Choice

If the primary key of a table is clumsy because it has too many attributes and is replaced by a new, single attribute key, ____.

• A) it becomes the new primary key of its own table
• B) it should replace the old primary key where it was used as a foreign key for one-to-many relationships
• C) it should replace the old primary key where it was used as a foreign key for many-to-many relationships
• D) All of the above.
• E) None of the above.

---

Definitions:

Wholesaler

A person or company that sells goods in large quantities at low prices, typically to retailers rather than directly to end users.

Rack Jobber

A merchandising agent or vendor who rents space within retail stores to sell goods, often responsible for managing inventory and setup.

Consignment

A supply arrangement where goods are left with a third party to sell, but the ownership remains with the supplier until sold.

Wholesaler

An entity involved in the business of selling goods in large quantities at low prices to retailers or other businesses, rather than to the general public.