We have normalized a table into BCNF if all candidate keys are determinants.
A. True
B. False
Answer: Option B
This Question Belongs to Database >> Database Design Using Normalization
Join The Discussion
Comments ( 1 )
Related Questions on Database Design Using Normalization
Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
A. advantage
B. disadvantage
C. either an advantage or disadvantage
D. neither an advantage nor disadvantage
Eliminating modification anomalies is a(n) ________ of normalization.
A. advantage
B. disadvantage
C. either an advantage or disadvantage
D. neither an advantage nor disadvantage
A. first step.
B. second step.
C. third step.
D. fourth step.
A relation is in BCNF, if and only if, every determinant is a candidate key.
The difference between 3NF and BCNF is that for a functional dependency A > B, 3NF allows this dependency in a relation if B is a primary key attribute and A is not a candidate key, whereas BCNF insists that for this dependency to remain in a relation, A must be a candidate key.