MADE EASY FREE TEST Q47

Question

Find the total number of tables required.

Ans given was 4, bit how can it be 4? According to me, E1 and E2 will require 2 tables at begining, then for E3 and E1 we need another table, then for E2 and E3 we need another and for E3 and E2’s many to many relation i need another one. So total =5.

But ans given was 4.. explain pls.

Answer 1

minimum FOUR tables are required to translate this E-R to RDBMS.

Answer 2

E1 and E2 would require 1 table as it is one to one relationship and has primary key of their own they can be combined to form one table

Therefore total 4 required