Stage 5: Derive the logical data model
Knobit of Data modelling · K-503 · Skill
Recognises a deletion anomaly in a logical data model
What it means
Deleting one fact deletes another that should have survived.
How it is assessed
Flags the deficient case and passes the acceptable one. Deficient: Branch BIC held only on Account; the branch's last account is closed and purged and the BIC goes with it Acceptable: Branch holds the BIC; Account references Branch
Builds on
- Explains the insertion, update and deletion anomaliesK-553 · Knowledge