search
Log In
0 votes
172 views

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.

in Databases 172 views
0

No need to merge E1 and E2... why would u do that?

Approach : 

  • First of all, count the no. of strong entity sets
  • Count no. of multivalued attributes
  • Count no. of weak entity sets
  • Count no. of M : N relationship sets

Please log in or register to answer this question.

Related questions

0 votes
0 answers
1
119 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?
asked Dec 18, 2018 in Databases Shamim Ahmed 119 views
0 votes
0 answers
2
464 views
Consider ER Diagram Identify the Minimum number of relation satisfying 2nf ? A. 1 B. 2 C. 3 D. 4
asked Oct 12, 2018 in Databases Na462 464 views
3 votes
1 answer
3
340 views
Is multivalued attribute always create extra table in ER diagram?
asked Oct 7, 2018 in Databases srestha 340 views
0 votes
0 answers
4
181 views
Tables needed for ER diagram
asked Sep 23, 2018 in Databases Mk Utkarsh 181 views
...