Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 353
|
Any binary relation is in
|
1 NF
|
|
|
2 NF
|
|
|
3 NF
|
|
|
BCNF
|
Question 353 Explanation:
Every binary relation(relation with two attributes ) is always in BCNF.
Let there be relation R(C,D).
Possible functional dependencies are,
C->D (Candidate key C)
or
D->C (Candidate key is D)
or
CD->CD (Candidate key is CD)
No violation is there in any of the above three cases for BCNF.
Let there be relation R(C,D).
Possible functional dependencies are,
C->D (Candidate key C)
or
D->C (Candidate key is D)
or
CD->CD (Candidate key is CD)
No violation is there in any of the above three cases for BCNF.
Correct Answer: D
Question 353 Explanation:
Every binary relation(relation with two attributes ) is always in BCNF.
Let there be relation R(C,D).
Possible functional dependencies are,
C->D (Candidate key C)
or
D->C (Candidate key is D)
or
CD->CD (Candidate key is CD)
No violation is there in any of the above three cases for BCNF.
Let there be relation R(C,D).
Possible functional dependencies are,
C->D (Candidate key C)
or
D->C (Candidate key is D)
or
CD->CD (Candidate key is CD)
No violation is there in any of the above three cases for BCNF.