Stage 5: Derive the logical data model
Knobit of Data modelling · K-533 · Skill
Decomposes an entity along a functional dependency without loss
What it means
Repairs a normal-form violation by moving the determinant and its dependents into an entity of their own, losslessly and preserving dependencies.
How it is assessed
The shared attributes are a key of one part, no dependency is left spanning two entities, and the dependent attributes move with their determinant
Builds on
- Explains lossless-join decompositionK-563 · Knowledge
- Explains dependency preservationK-564 · Knowledge
Needed by
- None