987 views

3 Answers

3 votes
3 votes

3 for entities, 1 for multivalued attribute with E1 and 4 for four many to many(M-N) relationships.

Total = 8

1 votes
1 votes

4 Tables are required at minimum

Reason:

R3 can merge with E2

E2R3 can merge with R1

R1E2R3 cannot merge with E1, Hence separate table is required for R1E2R3

Now R4 cannot merge with E3, Hence separate table is required for R4

E3 can merge with R2

E3R2 can merge with E1, Hence separate table is required for E3R2

E1 has a multivalued attribute, Hence separate table is required for it.

 

         

0 votes
0 votes

Each M:N relation requires separate table. So 4 tables for each relation.

Each multivalued attribute requires one table. So 1 table for the only one multivalued attribute of E1.

Last, 3 tables for three entities for E1 E2 and E3. So total 8 tables.

Related questions

0 votes
0 votes
2 answers
1
Balaji Jegan asked Nov 4, 2018
2,202 views
How many minimum number of tables needed for this Quaternary Relationship?
2 votes
2 votes
4 answers
3