422 views
1 votes
1 votes

How to solve these type of questions https://gateoverflow.in/201404/er-diagram

Copying the image for quick reference:

Minimum no of tables.

My approach was:

First allocate all the relationships to entities (i.e decide on relationships)

            So here R5 goes with E4 , R4 with E3, R2 with E2, R3 needs a separate table(relation) because of M:N, R1 for E2 as well.

Secondly see any tables can be merged.

           E1E2 can be merged (only this is possible)

So finally tables will be E1R1E2R2, E4R5, E3R4, R3.

Correct me if I’m wrong. Let me know if there is a better process.

Please log in or register to answer this question.

Related questions

0 votes
0 votes
0 answers
1
practicalmetal asked Oct 26, 2023
359 views
Can someone please provide me with the correct explanation for this question
0 votes
0 votes
0 answers
2
Shamim Ahmed asked Dec 18, 2018
305 views
How 1:1 cardinality with total participation of atleast 1 entity needs min no. of tables = 1 ?1:1 with partial participation of both entities needs min no of tables = 2?
0 votes
0 votes
0 answers
3
Na462 asked Oct 12, 2018
1,127 views
Consider ER Diagram Identify the Minimum number of relation satisfying 2nf ?A. 1B. 2C. 3D. 4
3 votes
3 votes
1 answer
4
srestha asked Oct 7, 2018
945 views
Is multivalued attribute always create extra table in ER diagram?