If you have two entities that are related with a cardinality pattern of (1,1) - (1,N) how many tables must you include in a correctly designed database to represent this entity-relationship cluster?
A) one
B) two
C) three
D) four
E) five

Question

Quizplus · Accepted Answer

In a (1,1) - (1,N) relationship, you need two tables: one for each entity. The table on the "N" side will have a foreign key referencing the primary key of the table on the "1" side.

If You Have Two Entities That Are Related with a Cardinality