2,609 views
5 votes
5 votes

How many minimum relations required for the above ER diagram?

According to me it should be 7. Please let me know the answer according to you.

1 Answer

0 votes
0 votes
Minimum 5 tables are required. For M:N (R1& R2) relationship count 2 tables, then for one side total participation, for such pair of entities we require 1 table for each relation (E1 R4 E4    &     E2 R3 E3). Now, see we have 1:1 relationship between E4 and E3, we can add it in either E4’s or E3’s table. Now, the remaining R6 E5 can be merged to form another table. So, in total (E1R4E4),(E2R3E3R5),(R1),(R2),(R6E5) tables can be formed.

Related questions

3 votes
3 votes
2 answers
1
0 votes
0 votes
2 answers
2
Balaji Jegan asked Nov 4, 2018
2,202 views
How many minimum number of tables needed for this Quaternary Relationship?
15 votes
15 votes
13 answers
3
targate2018 asked Aug 12, 2017
8,614 views
How many minimum relations required for given ER diagram ?
11 votes
11 votes
4 answers
4
targate2018 asked Aug 11, 2017
11,493 views
The minimum number of tables to represent ER-Diagram such that the relational database satisfies 1NF.