BCNF – Boyce–Codd Normal Form
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. How is Boyce–Codd Normal Form (BCNF) related to Third Normal Form?
2. What is the formal condition for a table to be in Boyce–Codd Normal Form?
3. In the loan approval BCNF example with LoanID, ProductType and InterestRate, which functional dependency causes the problem?
4. Why does the table with LoanID as primary key and the dependency ProductType → InterestRate violate Boyce–Codd Normal Form?
5. What anomaly arises when InterestRate is stored in the Loan table alongside ProductType?
6. How is the LoanID, ProductType, InterestRate table decomposed to satisfy Boyce–Codd Normal Form?
7. What is the key difference between Third Normal Form and Boyce–Codd Normal Form?
8. In practice, how do most well-designed 3NF schemas relate to Boyce–Codd Normal Form?
9. Which of the following is NOT a claim made about Boyce–Codd Normal Form?
10. What do the normal forms beyond Boyce–Codd Normal Form address?