5. etapp

Loogilise andmemudeli tuletamine

Tuletab normaliseeritud loogilise andmemudeli ja seob anomaaliad nende põhjustega

56 knobitit (20 teadmist, 36 oskust) · Tulemus: logical model · Tugineb: Kontseptuaalse mudeli ja taksonoomiate koostamine

Knobitite kaart

Iga märk on üks knobit. Ülemised knobitid tuginevad alumistele; vali üks, et see avada.

Ring: oskus
Ruut: teadmine

Selle etapi knobitid

Knobit		Liik
K-501	Recognises an insertion anomaly in a logical data model	Oskus
K-502	Recognises an update anomaly in a logical data model	Oskus
K-503	Recognises a deletion anomaly in a logical data model	Oskus
K-504	Recognises a repeating group in an entity	Oskus
K-505	Recognises an attribute holding several facts	Oskus
K-506	Recognises an attribute with several meanings	Oskus
K-507	Recognises attributes held as name-value rows	Oskus
K-508	Recognises a partial dependency on a composite key	Oskus
K-509	Recognises a transitive dependency between non-key attributes	Oskus
K-510	Recognises a stored derivable attribute	Oskus
K-511	Recognises a non-superkey determinant in a 3NF entity	Oskus
K-512	Recognises independent multi-valued facts in one entity	Oskus
K-513	Recognises a join dependency kept in one entity	Oskus
K-514	Recognises a lossy decomposition	Oskus
K-515	Recognises a functional dependency lost in a decomposition	Oskus
K-516	Recognises attributes inapplicable to some instances	Oskus
K-517	Recognises an unstable or meaningful primary key	Oskus
K-518	Recognises an entity identified only by a system-assigned key	Oskus
K-519	Recognises undeclared subtype constraints	Oskus
K-520	Recognises independently changing histories in one entity	Oskus
K-521	Recognises an unresolved many-to-many relationship	Oskus
K-522	Recognises a polymorphic association	Oskus
K-523	Recognises a connection trap	Oskus
K-524	Recognises a fan trap	Oskus
K-525	Recognises a chasm trap	Oskus
K-526	Recognises a redundant relationship	Oskus
K-527	Recognises overlapping entities	Oskus
K-528	Recognises one entity split by value into several	Oskus
K-529	Recognises a relationship contradicting its data rule	Oskus
K-530	Recognises a constraint implied by neither keys nor domains	Oskus
K-531	Traces a logical-model anomaly to its structural cause	Oskus
K-532	Records the functional dependencies of an entity	Oskus
K-533	Decomposes an entity along a functional dependency without loss	Oskus
K-534	Resolves a many-to-many relationship into an associative entity	Oskus
K-535	Replaces a repeating group with a dependent entity	Oskus
K-536	Introduces subtypes for attributes applying to only some instances	Oskus
K-551	Explains functional dependency	Teadmine
K-552	Explains candidate key and prime attribute	Teadmine
K-553	Explains the insertion, update and deletion anomalies	Teadmine
K-554	Explains first normal form	Teadmine
K-555	Explains second normal form	Teadmine
K-556	Explains third normal form	Teadmine
K-557	Explains Boyce-Codd normal form	Teadmine
K-558	Explains multivalued dependency and fourth normal form	Teadmine
K-559	Explains join dependency and fifth normal form	Teadmine
K-560	Explains sixth normal form for temporal data	Teadmine
K-561	Explains domain-key normal form	Teadmine
K-562	Explains attribute domains	Teadmine
K-563	Explains lossless-join decomposition	Teadmine
K-564	Explains dependency preservation	Teadmine
K-565	Explains derived data and point-in-time snapshots	Teadmine
K-566	Explains supertype and subtype constraints	Teadmine
K-567	Explains relationship cardinality and optionality	Teadmine
K-568	Explains natural keys, surrogate keys and key stability	Teadmine
K-569	Explains the connection, fan and chasm traps	Teadmine
K-570	Explains an entity type as the realisation of one business concept	Teadmine