Register

ER Diagram Table

• edited by
343 views
0 votes
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.

• edited by
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

299
views
0 answers
0 votes
Na462 asked May 15, 2018
299 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 ... be total this side.Also cardinality of strong to weak entity is "one to many".
User Avatar
1.4k
views
1 answers
1 votes
Na462 asked May 12, 2018
1,445 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 i am weak in ER Diagram to table conversion Please
User Avatar
514
views
1 answers
3 votes
ashish pal asked Jan 25, 2018
514 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 combine Department and Project.
User Avatar
451
views
0 answers
0 votes
practicalmetal asked Oct 26, 2023
451 views
ER Diagram
Can someone please provide me with the correct explanation for this question
User Avatar
Link Copied!