Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Filter
Profile
Wall
Recent activity
All questions
All answers
Exams Taken
All Blogs
Questions by uzumzki
0
votes
3
answers
1
if natural join is done then min and max no. of tuples if referential integrity is taken and not
R(ABC) S(BDE) F:A->B B ->C B->D D->E AND R HAS 100 TUPLES AND S HAS 200
R(ABC) S(BDE)F:A->B B ->C B->D D->EAND R HAS 100 TUPLES AND S HAS 200
2.0k
views
asked
Aug 17, 2015
Databases
natural-join
referential-integrity
+
–
4
votes
2
answers
2
The following functional dependency hold for relations
The following functional dependency hold for relations R (A,B,C) and S(B,D,E):FD FOR BOTH THE TABLES B -> A, A -> C The relation R contains 200 tuples and the relation s contains 100 tuples. What is the maximum 4 number of tuples possible in natural join R|><|S?
The following functional dependency hold for relations R (A,B,C) and S(B,D,E):FD FOR BOTH THE TABLES B - A, A - C The relation R contains 200 tuples and the relation s c...
6.0k
views
asked
Aug 11, 2015
Databases
database-normalization
+
–
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register