If the Primary Key of a Table Is Clumsy Because

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.