5. etapp: Loogilise andmemudeli tuletamine
Kompetentsi Andmete modelleerimine knobit · K-508 · Oskus
Recognises a partial dependency on a composite key
Mida see tähendab
In an entity with a composite key, a non-key attribute depends on only part of the key.
Kuidas seda hinnatakse
Flags the deficient case and passes the acceptable one. Deficient: Instalment keyed by (Loan Identifier, Instalment Number) carries Loan Maturity Date, which depends on Loan Identifier alone Acceptable: Loan Maturity Date on Loan; Instalment holds only facts about the instalment (`LOG-019`)
Tugineb
- Explains second normal formK-555 · Teadmine
Vajalik
- Puudub