...
Database-Management-System
August 29, 2024
Transactions
August 29, 2024
Database-Management-System
August 29, 2024
Transactions
August 29, 2024

Database-Management-System

Question 414
Which of the following relation schema is always in BCNF?
A
R( A,B,C,D)
B
R( A,B,C)
C
R( A,B,C,D,E)
D
R( A,B)
Question 414 Explanation: 
BCNF Properties:
1. BCNF is the advance version of 3NF. It is stricter than 3NF.
2. A table is in BCNF if every functional dependency X → Y, X is the super key of the table.
3. For BCNF, the table should be in 3NF, and for every FD, LHS is super key.
4. Two (or) Binary tuples are always be in BCNF
Correct Answer: D
Question 414 Explanation: 
BCNF Properties:
1. BCNF is the advance version of 3NF. It is stricter than 3NF.
2. A table is in BCNF if every functional dependency X → Y, X is the super key of the table.
3. For BCNF, the table should be in 3NF, and for every FD, LHS is super key.
4. Two (or) Binary tuples are always be in BCNF
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x