Frank does not want to use numbers to identify customers or employees in his database. Which of the following tables would likely require a compound primary key: (i) customer table, (ii) employee table?

Question

Quizplus · Accepted Answer

Both the customer and employee tables may require a compound primary key since using names or other non-numeric identifiers could result in duplicates. A compound primary key consisting of multiple fields can ensure unique identification of each record in the table.

Frank Does Not Want to Use Numbers to Identify Customers