1,566 views

2 Answers

1 votes
1 votes

foreign key: set of attribute reference to primary key or alternative key of same table or other table.
 

1000                               2000(here A value cant be different from R1(A))
R1(A(primary key) B C)    R2(A(foreighn key) D E)
      
minimum : consider all A in R2 are different but after 1000 different A they have to repeat since R1(A) are unique then each value of   R2(A) is matched twice in R1(A).
R2(A) value can be NULL if you don't consider R1(A) as Primary key.
X= number of record = 2000 or 0 

maximum : consider all A in R2 are same then matched to only value of R1(A)
Y=number of record in join = 2000 

                X+Y = 4000.or 2000

edited by

Related questions

0 votes
0 votes
1 answer
1
srestha asked Dec 16, 2017
1,523 views
Consider the relation schema:Student(roll no, name course no)Enroll(roll no, course no,course name)The number of tuples in the student and enroll table is 30 and 40 respe...
3 votes
3 votes
2 answers
2
iarnav asked Dec 6, 2017
1,257 views
Say we have two relations R (a,b,c) and S (b,d,e).Now, R has 200 tuples and S has 300 tuples. What will be Minimum number of tuples when we do R ⋈ S ( ⋈ = Natural Joi...
2 votes
2 votes
1 answer
3
4 votes
4 votes
4 answers
4
kauray asked May 9, 2017
3,685 views
Suppose you are given relations r(A, B) and s(A, C). Suppose that r has 10000 tuples, and s has 5000 tuples. Suppose attribute r.A has 1001 distinct values, and s.A also ...