@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix knobit: <https://knobit.org/id/knobit/> .
@prefix outcome: <https://knobit.org/id/outcome/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .

outcome:LO-5 a edu:LearningOutcome,
        edu:Skill ;
    rdfs:label "Derives a normalised logical data model and traces anomalies to their causes"@en,
        "Tuletab normaliseeritud loogilise andmemudeli ja seob anomaaliad nende põhjustega"@et ;
    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/> ;
    edu:hasPrerequisite outcome:LO-4 ;
    edu:includesKnobit knobit:K-501,
        knobit:K-502,
        knobit:K-503,
        knobit:K-504,
        knobit:K-505,
        knobit:K-506,
        knobit:K-507,
        knobit:K-508,
        knobit:K-509,
        knobit:K-510,
        knobit:K-511,
        knobit:K-512,
        knobit:K-513,
        knobit:K-514,
        knobit:K-515,
        knobit:K-516,
        knobit:K-517,
        knobit:K-518,
        knobit:K-519,
        knobit:K-520,
        knobit:K-521,
        knobit:K-522,
        knobit:K-523,
        knobit:K-524,
        knobit:K-525,
        knobit:K-526,
        knobit:K-527,
        knobit:K-528,
        knobit:K-529,
        knobit:K-530,
        knobit:K-531,
        knobit:K-532,
        knobit:K-533,
        knobit:K-534,
        knobit:K-535,
        knobit:K-536,
        knobit:K-551,
        knobit:K-552,
        knobit:K-553,
        knobit:K-554,
        knobit:K-555,
        knobit:K-556,
        knobit:K-557,
        knobit:K-558,
        knobit:K-559,
        knobit:K-560,
        knobit:K-561,
        knobit:K-562,
        knobit:K-563,
        knobit:K-564,
        knobit:K-565,
        knobit:K-566,
        knobit:K-567,
        knobit:K-568,
        knobit:K-569,
        knobit:K-570,
        knobit:K-581,
        knobit:K-582,
        knobit:K-583 ;
    edu:relatedTopic <https://knobit.org/id/topic/dmbok2-data-modelling> .

edu:LearningOutcome rdfs:label "Learning outcome"@en,
        "Õpiväljund"@et .

edu:Skill rdfs:label "Skill"@en,
        "Oskus"@et .

knobit:K-501 rdfs:label "Recognises an insertion anomaly in a logical data model"@en .

knobit:K-502 rdfs:label "Recognises an update anomaly in a logical data model"@en .

knobit:K-503 rdfs:label "Recognises a deletion anomaly in a logical data model"@en .

knobit:K-504 rdfs:label "Recognises a repeating group in an entity"@en .

knobit:K-505 rdfs:label "Recognises an attribute holding several facts"@en .

knobit:K-506 rdfs:label "Recognises an attribute with several meanings"@en .

knobit:K-507 rdfs:label "Recognises attributes held as name-value rows"@en .

knobit:K-508 rdfs:label "Recognises a partial dependency on a composite key"@en .

knobit:K-509 rdfs:label "Recognises a transitive dependency between non-key attributes"@en .

knobit:K-510 rdfs:label "Recognises a stored derivable attribute"@en .

knobit:K-511 rdfs:label "Recognises a non-superkey determinant in a 3NF entity"@en .

knobit:K-512 rdfs:label "Recognises independent multi-valued facts in one entity"@en .

knobit:K-513 rdfs:label "Recognises a join dependency kept in one entity"@en .

knobit:K-514 rdfs:label "Recognises a lossy decomposition"@en .

knobit:K-515 rdfs:label "Recognises a functional dependency lost in a decomposition"@en .

knobit:K-516 rdfs:label "Recognises attributes inapplicable to some instances"@en .

knobit:K-517 rdfs:label "Recognises an unstable or meaningful primary key"@en .

knobit:K-518 rdfs:label "Recognises an entity identified only by a system-assigned key"@en .

knobit:K-519 rdfs:label "Recognises undeclared subtype constraints"@en .

knobit:K-520 rdfs:label "Recognises independently changing histories in one entity"@en .

knobit:K-521 rdfs:label "Recognises an unresolved many-to-many relationship"@en .

knobit:K-522 rdfs:label "Recognises a polymorphic association"@en .

knobit:K-523 rdfs:label "Recognises a connection trap"@en .

knobit:K-524 rdfs:label "Recognises a fan trap"@en .

knobit:K-525 rdfs:label "Recognises a chasm trap"@en .

knobit:K-526 rdfs:label "Recognises a redundant relationship"@en .

knobit:K-527 rdfs:label "Recognises overlapping entities"@en .

knobit:K-528 rdfs:label "Recognises one entity split by value into several"@en .

knobit:K-529 rdfs:label "Recognises a relationship contradicting its data rule"@en .

knobit:K-530 rdfs:label "Recognises a constraint implied by neither keys nor domains"@en .

knobit:K-531 rdfs:label "Traces a logical-model anomaly to its structural cause"@en .

knobit:K-532 rdfs:label "Records the functional dependencies of an entity"@en .

knobit:K-533 rdfs:label "Decomposes an entity along a functional dependency without loss"@en .

knobit:K-534 rdfs:label "Resolves a many-to-many relationship into an associative entity"@en .

knobit:K-535 rdfs:label "Replaces a repeating group with a dependent entity"@en .

knobit:K-536 rdfs:label "Introduces subtypes for attributes applying to only some instances"@en .

knobit:K-551 rdfs:label "Explains functional dependency"@en .

knobit:K-552 rdfs:label "Explains candidate key and prime attribute"@en .

knobit:K-553 rdfs:label "Explains the insertion, update and deletion anomalies"@en .

knobit:K-554 rdfs:label "Explains first normal form"@en .

knobit:K-555 rdfs:label "Explains second normal form"@en .

knobit:K-556 rdfs:label "Explains third normal form"@en .

knobit:K-557 rdfs:label "Explains Boyce-Codd normal form"@en .

knobit:K-558 rdfs:label "Explains multivalued dependency and fourth normal form"@en .

knobit:K-559 rdfs:label "Explains join dependency and fifth normal form"@en .

knobit:K-560 rdfs:label "Explains sixth normal form for temporal data"@en .

knobit:K-561 rdfs:label "Explains domain-key normal form"@en .

knobit:K-562 rdfs:label "Explains attribute domains"@en .

knobit:K-563 rdfs:label "Explains lossless-join decomposition"@en .

knobit:K-564 rdfs:label "Explains dependency preservation"@en .

knobit:K-565 rdfs:label "Explains derived data and point-in-time snapshots"@en .

knobit:K-566 rdfs:label "Explains supertype and subtype constraints"@en .

knobit:K-567 rdfs:label "Explains relationship cardinality and optionality"@en .

knobit:K-568 rdfs:label "Explains natural keys, surrogate keys and key stability"@en .

knobit:K-569 rdfs:label "Explains the connection, fan and chasm traps"@en .

knobit:K-570 rdfs:label "Explains an entity type as the realisation of one business concept"@en .

knobit:K-581 rdfs:label "Expresses a logical model as a UML class diagram"@en .

knobit:K-582 rdfs:label "Models data as fact types in a fact-based scheme"@en .

knobit:K-583 rdfs:label "Maps an application model onto a canonical model"@en .

outcome:LO-4 rdfs:label "Builds a conceptual model and its taxonomies"@en,
        "Koostab kontseptuaalse mudeli ja selle taksonoomiad"@et .

<https://knobit.org/id/topic/dmbok2-data-modelling> rdfs:label "Data modelling and design (DAMA-DMBOK2 chapter 5)"@en,
        "Andmete modelleerimine ja disain (DAMA-DMBOK2 5. peatükk)"@et .