Derives a normalised logical data model and traces anomalies to their causes

https://knobit.org/id/outcome/LO-5

dcterms:description	Stage 3 (Logical model) of the data-modelling skill: Derives a normalised logical data model and traces anomalies to their causes; produces 03-logical/logical-model.yaml. en
dcterms:identifier	LO-5
dcterms:license	https://creativecommons.org/licenses/by/4.0/
has prerequisite	Builds a conceptual model and its taxonomies
includes knobit	Recognises an insertion anomaly in a logical data model
includes knobit	Recognises an update anomaly in a logical data model
includes knobit	Recognises a deletion anomaly in a logical data model
includes knobit	Recognises a repeating group in an entity
includes knobit	Recognises an attribute holding several facts
includes knobit	Recognises an attribute with several meanings
includes knobit	Recognises attributes held as name-value rows
includes knobit	Recognises a partial dependency on a composite key
includes knobit	Recognises a transitive dependency between non-key attributes
includes knobit	Recognises a stored derivable attribute
includes knobit	Recognises a non-superkey determinant in a 3NF entity
includes knobit	Recognises independent multi-valued facts in one entity
includes knobit	Recognises a join dependency kept in one entity
includes knobit	Recognises a lossy decomposition
includes knobit	Recognises a functional dependency lost in a decomposition
includes knobit	Recognises attributes inapplicable to some instances
includes knobit	Recognises an unstable or meaningful primary key
includes knobit	Recognises an entity identified only by a system-assigned key
includes knobit	Recognises undeclared subtype constraints
includes knobit	Recognises independently changing histories in one entity
includes knobit	Recognises an unresolved many-to-many relationship
includes knobit	Recognises a polymorphic association
includes knobit	Recognises a connection trap
includes knobit	Recognises a fan trap
includes knobit	Recognises a chasm trap
includes knobit	Recognises a redundant relationship
includes knobit	Recognises overlapping entities
includes knobit	Recognises one entity split by value into several
includes knobit	Recognises a relationship contradicting its data rule
includes knobit	Recognises a constraint implied by neither keys nor domains
includes knobit	Traces a logical-model anomaly to its structural cause
includes knobit	Records the functional dependencies of an entity
includes knobit	Decomposes an entity along a functional dependency without loss
includes knobit	Resolves a many-to-many relationship into an associative entity
includes knobit	Replaces a repeating group with a dependent entity
includes knobit	Introduces subtypes for attributes applying to only some instances
includes knobit	Explains functional dependency
includes knobit	Explains candidate key and prime attribute
includes knobit	Explains the insertion, update and deletion anomalies
includes knobit	Explains first normal form
includes knobit	Explains second normal form
includes knobit	Explains third normal form
includes knobit	Explains Boyce-Codd normal form
includes knobit	Explains multivalued dependency and fourth normal form
includes knobit	Explains join dependency and fifth normal form
includes knobit	Explains sixth normal form for temporal data
includes knobit	Explains domain-key normal form
includes knobit	Explains attribute domains
includes knobit	Explains lossless-join decomposition
includes knobit	Explains dependency preservation
includes knobit	Explains derived data and point-in-time snapshots
includes knobit	Explains supertype and subtype constraints
includes knobit	Explains relationship cardinality and optionality
includes knobit	Explains natural keys, surrogate keys and key stability
includes knobit	Explains the connection, fan and chasm traps
includes knobit	Explains an entity type as the realisation of one business concept
includes knobit	Expresses a logical model as a UML class diagram
includes knobit	Models data as fact types in a fact-based scheme
includes knobit	Maps an application model onto a canonical model
owl:sameAs	https://bitbucket.org/reffa/ontology/id/outcome/data-modelling/05-logical
rdfs:label	Derives a normalised logical data model and traces anomalies to their causes en
rdfs:label	Tuletab normaliseeritud loogilise andmemudeli ja seob anomaaliad nende põhjustega et
related topic	Data modelling and design (DAMA-DMBOK2 chapter 5)

Used by

assesses learning outcome	Seven retail banking designs in seven DMBOK2 modelling schemes (scheme design skills)
assesses learning outcome	Data modelling knowledge: Logical modelling and normalisation (CDMP-style questions)
assesses learning outcome	Retail banking servicing logical model (higher normal forms, decomposition and path anomaly skills)
assesses learning outcome	Loan application logical model (normalisation anomaly skills)
assesses learning outcome	Party taxonomy (data taxonomy skills)
assesses learning outcome	Loan application physical model on Snowflake (physical design anomaly skills)
has prerequisite	Designs a physical data model for the target platform without introducing anomalies
includes learning outcome	Learning path: Data modelling
related learning outcome	Stage 4 — The logical data model
related learning outcome	Logical model anomaly checklist
schema:item	https://knobit.org/id/path/data-modelling/LO-5