Question

Please show three examples of binary relationship with maximum cardinality of 1:1, 1:N, and N:M (one for each).

For each example,

Identify two entities and their primary keys
Identify and justify the maximum cardinality
Now that we have we had three examples of binary relationship with maximum cardinality of 1:1, 1:N, and N:M (one for each).

In addition, please refine the cardinality. For each example you had:

Identify 3 or 4 attributes (including primary key) for each entity.
Place foreign key.
Identify and justify the minimum cardinality
Expert Answer

Answer 1

ANSWER:

GIVEN THAT:

Binary relations are the relationships that are defined between two entities. Below are the explanation with examples on each cardinality.

1. One to One cardinality with Primary key:-

2. One to Many cardinality with Primary key:-

3. Many to Many cardinality with Primary key:-

Cardinalities with attributes

1. One to One with Primary and Foreign key:-

2. One to Many with Primary and Foreign key:-

3). Many to Many with Primary and Foreign key:-