Register

ER Diagram Table

• edited by
545 views
0 0 votes

Minimum number of Relations:-  

The Answer is $5$. Please see my Reason behind it:- 

1. $R_6$ and $E_5$ CAN be merged giving $1$ relation we cant merge with $E_3$, because its a strong entity even though the participation is total.

2. $E_1$ and $E_4$ Gives total of $1$ relation.

3. $R_1$ Will have its separate relation

3.$E_2$, $E_3$ , $R_3$, and $R_5$ can be merged.

4. $R_2$ will have separate table because of many to many (Doubt here)

Hence total $5$ tables we got.

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · #computer-network #N...Next → · #Algorithm Bellman F...
← Previous in category · MadeEasy Test Series...Next in category → · B+ tree Index
Position:
Show:

Related questions

0 0 votes
0 0 answers
453
453 views
Na462 asked May 15, 2018
453 views
ER Diagram to Table Doubt
1. If in a Question it says that find minimum number of tables and doesn't say anything that it should satisfy 1nf or 2nf then what we should consider by default while fi...
1 1 vote
1 1 answer
2.6k
2.6k views
Na462 asked May 12, 2018
2,599 views
Er Diagram to Table 1
The number of minimum Relations which satisfy 1NF _________. (Partial participation between E1 and R should not lost in RDBMS design).Please explain every point in detail...
3 3 votes
1 1 answer
977
977 views
ashish pal asked Jan 25, 2018
977 views
Ace Test Series: DBMS - ER Diagram To Relational Table
Answer given is 3But my answer is 2 . I have combined the Department and Project relation since the participation of Project was total.please someone explain why can't we...
4 4 votes
0 0 answers
891
891 views
practicalmetal asked Oct 26, 2023
891 views
ER Diagram
Can someone please provide me with the correct explanation for this question