Let E1 and E2 be two entities and R is a relation between E1 and E2, then what is the minimum no of tables required to represent E1, E2 and R if E1 and E2 have 1:m cardinality (E1 on 1 side, E2 on m side); E2 has total participation and E1 has partial participation.
(A) 3
(B) 2
(C) 0
(D) 4


Answer: (B)

Explanation: If relationship is many to one and one side entity is only partially participation. Then it is not possible to merge in one table.
Therefore, 2 tables required.

Option (B) is correct.

Quiz of this Question