The Gateway to Computer Science Excellence
+1 vote
195 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 (117 points)
edited by | 195 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..
+1
  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,833 questions
57,691 answers
199,329 comments
107,350 users