5. etapp: Loogilise andmemudeli tuletamine
Kompetentsi Andmete modelleerimine knobit · K-502 · Oskus
Recognises an update anomaly in a logical data model
Mida see tähendab
One fact is stored in several rows, so a change must be repeated and a partial change leaves the data contradicting itself.
Kuidas seda hinnatakse
Flags the deficient case and passes the acceptable one. Deficient: Account holder address held on every Account; the customer moves and three of their five accounts are updated Acceptable: Address held once on Party; Account reaches it through Account Holder
Tugineb
- Explains the insertion, update and deletion anomaliesK-553 · Teadmine
Vajalik
- Recognises an unmanaged duplicate columnK-601 · Oskus