Derive the logical data model

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

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

Used by

consists of	Data modelling