@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-6 a edu:LearningOutcome,
        edu:Skill ;
    rdfs:label "Designs a physical data model for the target platform without introducing anomalies"@en,
        "Kujundab sihtplatvormile füüsilise andmemudeli uusi anomaaliaid tekitamata"@et ;
    dcterms:description "Stage 4 (Physical model) of the data-modelling skill: Designs a physical data model for the target platform without introducing anomalies; produces 04-physical/physical-model.yaml."@en ;
    dcterms:identifier "LO-6" ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    edu:hasPrerequisite outcome:LO-5 ;
    edu:includesKnobit knobit:K-310,
        knobit:K-313,
        knobit:K-601,
        knobit:K-602,
        knobit:K-603,
        knobit:K-604,
        knobit:K-605,
        knobit:K-606,
        knobit:K-607,
        knobit:K-608,
        knobit:K-609,
        knobit:K-610,
        knobit:K-611,
        knobit:K-612,
        knobit:K-613,
        knobit:K-616,
        knobit:K-617,
        knobit:K-618,
        knobit:K-620,
        knobit:K-621,
        knobit:K-622,
        knobit:K-623,
        knobit:K-624,
        knobit:K-625,
        knobit:K-626,
        knobit:K-627,
        knobit:K-628,
        knobit:K-629,
        knobit:K-630,
        knobit:K-641,
        knobit:K-651,
        knobit:K-652,
        knobit:K-653,
        knobit:K-654,
        knobit:K-655,
        knobit:K-656,
        knobit:K-657,
        knobit:K-658,
        knobit:K-659,
        knobit:K-660,
        knobit:K-661,
        knobit:K-662,
        knobit:K-671,
        knobit:K-672,
        knobit:K-673,
        knobit:K-674,
        knobit:K-705 ;
    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-310 rdfs:label "Recognises a constraint claimed by a rule and missing from the schema"@en .

knobit:K-313 rdfs:label "Recognises a declared constraint the target platform does not enforce"@en .

knobit:K-601 rdfs:label "Recognises an unmanaged duplicate column"@en .

knobit:K-602 rdfs:label "Recognises logical entities merged into one table"@en .

knobit:K-603 rdfs:label "Recognises a stored derived or summary value"@en .

knobit:K-604 rdfs:label "Recognises a lossy or unconstrained vertical split"@en .

knobit:K-605 rdfs:label "Recognises an entity split into clone tables by value"@en .

knobit:K-606 rdfs:label "Recognises rolled-up subtypes losing conditional constraints"@en .

knobit:K-607 rdfs:label "Recognises rolled-down subtypes losing supertype constraints"@en .

knobit:K-608 rdfs:label "Recognises a hierarchy encoded redundantly"@en .

knobit:K-609 rdfs:label "Recognises content held outside the database by reference"@en .

knobit:K-610 rdfs:label "Recognises a surrogate key without natural-key uniqueness"@en .

knobit:K-611 rdfs:label "Recognises a surrogate value with meaning, reused or renumbered"@en .

knobit:K-612 rdfs:label "Recognises an undeclared foreign key"@en .

knobit:K-613 rdfs:label "Recognises a referential action destroying what should survive"@en .

knobit:K-616 rdfs:label "Recognises a changeable value list fixed in the DDL"@en .

knobit:K-617 rdfs:label "Recognises a physical domain differing from the logical domain"@en .

knobit:K-618 rdfs:label "Recognises binary floating point used for an exact quantity"@en .

knobit:K-620 rdfs:label "Recognises a business fact held in physical row order"@en .

knobit:K-621 rdfs:label "Recognises an index set not derived from access paths"@en .

knobit:K-622 rdfs:label "Recognises an overwrite where history is required"@en .

knobit:K-623 rdfs:label "Recognises inconsistent validity periods in a versioned table"@en .

knobit:K-624 rdfs:label "Recognises a reference to a versioned table by business key alone"@en .

knobit:K-625 rdfs:label "Recognises a soft delete the constraints do not understand"@en .

knobit:K-626 rdfs:label "Recognises a fact table of mixed grain"@en .

knobit:K-627 rdfs:label "Recognises a measure without stated additivity"@en .

knobit:K-628 rdfs:label "Recognises a nullable foreign key on a reporting join path"@en .

knobit:K-629 rdfs:label "Recognises a sentinel value standing in for null"@en .

knobit:K-630 rdfs:label "Recognises a null with a business meaning"@en .

knobit:K-641 rdfs:label "Routes a defect to the deliverable responsible for it"@en .

knobit:K-651 rdfs:label "Explains controlled denormalisation"@en .

knobit:K-652 rdfs:label "Explains the implementation options for subtypes"@en .

knobit:K-653 rdfs:label "Explains referential integrity and referential actions"@en .

knobit:K-654 rdfs:label "Explains exact and approximate numeric types"@en .

knobit:K-655 rdfs:label "Explains null semantics and three-valued logic"@en .

knobit:K-656 rdfs:label "Explains value sets held as reference data"@en .

knobit:K-657 rdfs:label "Explains index design from access paths"@en .

knobit:K-658 rdfs:label "Explains history strategies and validity-period conventions"@en .

knobit:K-659 rdfs:label "Explains grain and additivity in dimensional models"@en .

knobit:K-660 rdfs:label "Explains vertical and horizontal partitioning of tables"@en .

knobit:K-661 rdfs:label "Explains consistency of content stored by reference"@en .

knobit:K-662 rdfs:label "Explains the absence of row order in relational tables"@en .

knobit:K-671 rdfs:label "Designs a star schema for a stated grain"@en .

knobit:K-672 rdfs:label "Designs a Data Vault model for auditable history"@en .

knobit:K-673 rdfs:label "Designs a document structure for a stated access pattern"@en .

knobit:K-674 rdfs:label "Designs views hiding physical structure from consumers"@en .

knobit:K-705 rdfs:label "Recognises history kept without its constraints checked"@en .

outcome:LO-5 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 .

<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 .