The Gateway to Computer Science Excellence
0 votes
134 views

ER- no of tables?

in Databases by Active (3.2k points) | 134 views
0
4? E1,E2,E3,R2
0

isn't R1 is m:n relationship as well which needs an another table? @Abhisek Tiwari 4

0
then also i think we can do it in 4 if no case for normalization is mentioned.

is there cardinality info?
0
no..but i think the given anwer is 3
0
i think 3 will be the answer
+2
0
If R1 is 1:1 with total participation on either side, then number of relations should be only 2.

E1E2R1(P,Q,R,S)  and E3R2(T,U,R)
0
but i don't think it's total participation on both sides..
0
Either doesn't mean both.
0
according to me it is 1:1 relationship with partial on either end(total+partial)
0

thanks @adarsh_1997 for pic. i was not sure about these rep and treated R2 as many to many.

i think u must be sure about correctness of this snap?

+1

I think it can be minimized ---- >  2 table 

right ??

Please log in or register to answer this question.

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,154 answers
193,757 comments
93,718 users