465 views
0 votes
0 votes

Lets Two relations

R1(P, Q, R)  R2(R, S, T)…….R1 contains 2500 tuples and R2 contains 2000 tuples

Q1)

R1(P, Q, R)  R2(R, S, T) ..’R’ is primary key in R1 and R is NOT FK in R2

MIN and MAX tuples in R1 * R2  .. (* ==> Natural Join)

Q2)

R1(P, Q, R)  R2(R, S, T) ..’R’ is primary key in R1 and R is FK in R2

MIN and MAX tuples in R1 * R2  .. (* ==> Natural Join)

Q1)

R1(P, Q, R)  R2(R, S, T) ..’R’ is NOT primary key in R1 and R is NOT FK in R2

MIN and MAX tuples in R1 * R2  .. (* ==> Natural Join)

 

Please log in or register to answer this question.

Related questions

4 votes
4 votes
0 answers
1
Shubhanshu asked May 3, 2017
2,515 views
Plz explain what is the no of tables required in self referential relation( without multivalued attribute) and How:- and also (with multivalued attribute) ????
1 votes
1 votes
1 answer
3
striver23 asked Feb 4, 2023
386 views
can we make weak entity type as composite attribute of another weak entity type?