The Gateway to Computer Science Excellence
0 votes
138 views

Find minimum number of tables needed?

Answer : (3)

Can anyone please explain the answer and how to approach such complex er diagrams?

in Databases by (111 points)
edited by | 138 views
+1

Is it 5?

E1(A,B,C,D)

E2(D,E,F,G)

E3(G,H,G)

E4(I,J,K,A)

R3(G,A)

0

That's what even I got...but the answer given is 4..and I can't understand how

0
T1 - E1,R1,E2  (1:1 and total participation from E1)

T2 - E3,R2,R4

T3 - R3 (M:N)

T4 - E4,R5

I think the answer is 4, can anyone tell me what else can be clubbed among these..
0
  1. E1E2R1R2(A,B,C,D,E,F,G) G IS FK FROM E3 TO E2
  2. R3(AG) BOTH  'A' AND 'G' ARE FK TO E1 AND E3 
  3. E4R5(I,J,K,A) 'A' IS FK TO E1
  4. E3R4(G,H,M)  'M' IS AS FK REFERENCING PK G

BOLD ONES ARE PRIMARY KEY, is it correct??

 

0
i think it will be 4

table 1 for E1 and E2 (it can be combined).

table 2 for E3

table 3 for E4

table 4 for M:N relationship

total 4 table.

Please log in or register to answer this question.

Related questions

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,666 questions
56,157 answers
193,767 comments
93,751 users