Which table(s) will have a compound primary key: (i) customer table, (ii) prepare drink/ingredients table?

Question

Quizplus · Accepted Answer

The prepare drink/ingredients table is more likely to have a compound primary key as it represents a many-to-many relationship between drinks and ingredients. The primary key could include both the drink ID and the ingredient ID, creating a compound primary key. The customer table may have a single primary key, such as a customer ID. Therefore, the correct answer is B, ii only.

Which Table(s) Will Have a Compound Primary Key: (I) Customer