How many tables are needed to implement an REA data model that has four distinct entities,three M:N relationships and one 1:N relationships in a relational database?
A)5
B)7
C)8
D)10

Question

Quizplus · Accepted Answer

For each of the four distinct entities, a separate table is needed. For each of the three M:N (many-to-many) relationships, an additional table is required to handle the relationship, making it three more tables. The 1:N (one-to-many) relationship does not require an additional table as it can be handled with a foreign key in the existing tables. Therefore, the total is 4 (entities) + 3 (M:N relationships) = 7 tables.

How Many Tables Are Needed to Implement an REA Data