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.

Question

Quizplus · Accepted Answer

When a new, single attribute key is introduced to replace a cumbersome primary key, it becomes the new primary key of its own table. Additionally, it should replace the old primary key wherever it was used as a foreign key, regardless of whether the relationships were one-to-many or many-to-many. This ensures consistency and integrity in the database schema.

If the Primary Key of a Table Is Clumsy Because