@prefix activity: <https://knobit.org/id/activity/> .
@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix knobit: <https://knobit.org/id/knobit/> .
@prefix owl: <http://www.w3.org/2002/07/owl#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix schema: <https://schema.org/> .
@prefix xsd: <http://www.w3.org/2001/XMLSchema#> .

activity:LO-6 a edu:Activity ;
    rdfs:label "Design the physical data model"@en,
        "Füüsilise andmemudeli kujundamine"@et ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    rdfs:comment "Stage 4 (Physical) of the data-modelling skill: produces 04-physical/physical-model.yaml and passes the stage's validation gate."@en ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/activity/data-modelling/06-physical> ;
    edu:requiresKnobit 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 ;
    schema:position 4 .

edu:Activity rdfs:label "Activity"@en,
        "Tegevusnäitaja"@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 .