The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
0 votes
60 views

ER- no of tables?

asked in Databases by Junior (953 points) | 60 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?

0

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

right ??

Please log in or register to answer this question.

Related questions

0 votes
0 answers
2
0 votes
0 answers
4


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

47,080 questions
51,333 answers
177,706 comments
66,675 users