Stage 6: Design the physical data model
Knobit of Data modelling · K-660 · Knowledge
Explains vertical and horizontal partitioning of tables
What it means
Splitting a table by columns or rows, and what keeps the parts one entity.
How it is assessed
Decides for sample splits whether they stay lossless and constrained
Builds on
- Explains lossless-join decompositionK-563 · Knowledge
Needed by
- Recognises a lossy or unconstrained vertical splitK-604 · Skill
- Recognises an entity split into clone tables by valueK-605 · Skill