Stage 5: Derive the logical data model
Knobit of Data modelling · K-557 · Knowledge
Explains Boyce-Codd normal form
What it means
Every determinant is a superkey; why a 3NF entity can still have anomalies.
How it is assessed
Finds the BCNF violation in a 3NF entity with overlapping candidate keys
Builds on
- Explains third normal formK-556 · Knowledge
Needed by
- Recognises a non-superkey determinant in a 3NF entityK-511 · Skill
- Explains multivalued dependency and fourth normal formK-558 · Knowledge