516 views
1 votes
1 votes

let R1 and R2 be relations α2 is set of attributes of R2.let α2 is foreign key in R2, referring to α1 of relation R1.

Consider the following points about above

1. α2 is primary key of R2.

2.  α1 is primary key of R1

3. α2 may or may not be primary key of R2

4. α1 may have null values

5. α1 need not be key of R1

whichiof the above is true

a) 1 and 2

b) 1,4 and 5

c)2 and 3

d)2,3 and 4

2 Answers

0 votes
0 votes

1. Its not necessary that a foreign key has to be the primary key of a relation. Therefore 1 is FALSE

2. Every foreign key must be the Primary key of the foreign relation. Therefore 2 is TRUE.

3. if 1 is False this is automatically TRUE.

4. Since a1 is primary key therefore it cant have null values. Therefore FLASE.

5. Already stated that a1 is primary key of R1. 

Therefore option C i.e. 2 and 3 are TRUE.

No related questions found