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.