Register
Filter

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
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...