Skip to content
Q61Section DA (Data Science and Artificial Intelligence (Q11–Q65))61 of 65

Minimum number of 3NF relations for an ER model with a multi-valued attribute and an M:N relationship

Consider an ER model with the entities E1(A11,A12,A13) and E2(A21,A22,A23), where, A11, A12, A13 are the attributes of E1, and A21, A22, A23 are the attributes of E2. Let A22 be a multi-valued attribute. A11 and A21 are the primary keys of E1 and E2, respectively. Let R12 be a many-to-many relationship between E1 and E2. Participation of both E1 and E2 in R12 is total. The minimum number of relations required to convert the ER model into relational model (assuming there is no other functional dependency) where each relation is in third normal form (3NF) is __________ . (Answer in integer)

Numerical answer: type the number (no options).

Type your answer and check it.