CHP5

Question 1

1:1
1:M
M:N
Provide an example for each of these:

Answer 1

a) 1:1 - PROFESSOR II——II DEPARTMENT
b) 1:M - PAINTER II——I< PAINTING
c) M:N - STUDENT >II——II< CLASS

Question 2

Explain how to resolve M:N relationship:

Answer 2

Break them up to produce a set of one-to-many relationships (1:M)
- Creating a bridge entity to connect between the two tables

Question 3

What is 1:M, 1:1, and 1:M relationship?

Answer 3

a) 1:M relationship - Should be the norm in any erd
b) 1:1 relationship - Should be the rarest in erd
c) M:N relationship - Cannot be implemented and changed to 1:M instead.