5. etapp: Loogilise andmemudeli tuletamine
Kompetentsi Andmete modelleerimine knobit · K-520 · Oskus
Recognises independently changing histories in one entity
Mida see tähendab
In an entity that keeps history, attributes that change independently share one row and one validity period, so a change to any one repeats all the others and "when did X change?" needs consecutive rows compared.
Kuidas seda hinnatakse
Flags the deficient case and passes the acceptable one. Deficient: Account Version (Account, valid from, account status, interest rate, servicing branch) Acceptable: One history per group of attributes that change together: Account Status History, Account Interest Rate History, each with its own validity
Tugineb
- Explains sixth normal form for temporal dataK-560 · Teadmine
Vajalik
- Puudub