Register

Self Doubt relate to ER diagrams(Databases).

667 views
0 0 votes

 

In (https://gateoverflow.in/219555/number-of-tables) number of tables to be made was 4, merging E1 and E2 in one table, one for R3, and for E3 and one for E4. 

Now based on that, how many tablesfor this er diagram. 

The answer is 6, 4 tables for entities ABCD and 2 tables for relationships R3 and R2, but if we consider the above question we should be able to merge B and D in a similar manner, I am confused regarding when to merge tables and when to not, someone please help me

 

1 Answer

Voting & Accepting an answer helps improve the community
← Previous · #TOC-regular-languag...Next → · geeksforgeeks
← Previous in category · PW DPP DBMS - Functi...Next in category → · 70%participation at ...
Position:
Show:

Related questions

2 2 votes
4 4 answers
2.9k
2.9k views
KISHALAY DAS asked Oct 25, 2016
2,921 views
General Topic Doubt Databases: Er Diagrams
1 1 vote
3 3 answers
2.5k
2.5k views
Ashutosh_17 asked Apr 13, 2023
2,543 views
Database ER model
An ER diagram is having two strong entities E1 and E2. The relationship between the entities ‘R’ is having partial participation from E1 side and total participation from...