ExamVeda
Login
Home

We have normalized a table into BCNF if all candidate keys...

This question belongs to Database Database Design Using Normalization
Database Design Using Normalization
?

We have normalized a table into BCNF if all candidate keys are determinants.

Answer & Solution
Correct Answer: Option B
Let's discuss the solution. Join the discussion
Examveda
Question posted by Examveda
Community

Join the Discussion

1 Comment
Zain-Abdeen Tanko
Zain-Abdeen Tanko 6 years ago
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.
Keep Learning

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
Multivalued dependencies should ________ be eliminated.
A. always B. commonly C. seldom D. never
When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
A. first step. B. second step. C. third step. D. fourth step.
More Related Questions on Database Design Using Normalization