1.

Explain Boyce and Codd form (BCNF).

Answer»

Boyce and Codd form (BCNF):

  • When a relation has more than one candidate key, anomalies may result even though the relation is in 3NF.
  • 3NFdoes not deal satisfactorily with the case of relation with overlapping candidate keys
  • BCNF is based on the concept of a determinant.
  • A determinant is any attribute on which some other attribute is fully functionally dependent.

A relation is in BCNF is, and only if, every determinant is a candidate key.



Discussion

No Comment Found

Related InterviewSolutions