5. etapp: Loogilise andmemudeli tuletamine
Kompetentsi Andmete modelleerimine knobit · K-563 · Teadmine
Explains lossless-join decomposition
Mida see tähendab
A split is lossless only if the shared attributes are a key of at least one part.
Kuidas seda hinnatakse
Decides for sample decompositions whether joining back produces spurious rows
Tugineb
- Explains candidate key and prime attributeK-552 · Teadmine
Vajalik
- Recognises a lossy decompositionK-514 · Oskus
- Decomposes an entity along a functional dependency without lossK-533 · Oskus
- Explains vertical and horizontal partitioning of tablesK-660 · Teadmine