@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 owl: <http://www.w3.org/2002/07/owl#> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .

outcome:LO-8 a edu:LearningOutcome,
        edu:Skill ;
    rdfs:label "Generates DDL per target dialect and reviews it against model, engine, data and deployment"@en,
        "Genereerib sihtmurdele DDL-i ja vaatab selle üle mudeli, andmebaasimootori, andmete ja juurutuse suhtes"@et ;
    dcterms:description "Stage 5 (DDL) of the data-modelling skill: Generates DDL per target dialect and reviews it against model, engine, data and deployment; produces 05-ddl/<dialect>/."@en ;
    dcterms:identifier "LO-8" ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/outcome/data-modelling/08-ddl> ;
    edu:hasPrerequisite outcome:LO-6 ;
    edu:includesKnobit knobit:K-310,
        knobit:K-313,
        knobit:K-356,
        knobit:K-618,
        knobit:K-641,
        knobit:K-801,
        knobit:K-802,
        knobit:K-803,
        knobit:K-804,
        knobit:K-806,
        knobit:K-808,
        knobit:K-809,
        knobit:K-810,
        knobit:K-811,
        knobit:K-812,
        knobit:K-813,
        knobit:K-814,
        knobit:K-816,
        knobit:K-817,
        knobit:K-819,
        knobit:K-820,
        knobit:K-821,
        knobit:K-822,
        knobit:K-823,
        knobit:K-824,
        knobit:K-825,
        knobit:K-826,
        knobit:K-827,
        knobit:K-828,
        knobit:K-851,
        knobit:K-852,
        knobit:K-853,
        knobit:K-854,
        knobit:K-855,
        knobit:K-856,
        knobit:K-857,
        knobit:K-858,
        knobit:K-859 ;
    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-356 rdfs:label "Explains rule enforcement mechanisms and platform enforcement"@en .

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

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

knobit:K-801 rdfs:label "Recognises generated SQL edited by hand"@en .

knobit:K-802 rdfs:label "Recognises DDL older than its model"@en .

knobit:K-803 rdfs:label "Recognises an object in the SQL missing from the model"@en .

knobit:K-804 rdfs:label "Recognises generator warnings carried without a decision"@en .

knobit:K-806 rdfs:label "Recognises a configured dialect left unregenerated"@en .

knobit:K-808 rdfs:label "Recognises a CHECK constraint parsed and ignored"@en .

knobit:K-809 rdfs:label "Recognises an expression running on one engine only"@en .

knobit:K-810 rdfs:label "Recognises a truncated identifier taken as the real name"@en .

knobit:K-811 rdfs:label "Recognises a reserved word used as an identifier"@en .

knobit:K-812 rdfs:label "Recognises a type meaning something else on another engine"@en .

knobit:K-813 rdfs:label "Recognises an index the target engine cannot create or run"@en .

knobit:K-814 rdfs:label "Recognises a foreign-key cycle taken as resolved"@en .

knobit:K-816 rdfs:label "Recognises one decimal scale for every currency"@en .

knobit:K-817 rdfs:label "Recognises a length taken from sample data"@en .

knobit:K-819 rdfs:label "Recognises a collation changing what a key means"@en .

knobit:K-820 rdfs:label "Recognises a default inventing a business fact"@en .

knobit:K-821 rdfs:label "Recognises a restricted column without access design"@en .

knobit:K-822 rdfs:label "Recognises greenfield DDL aimed at a populated database"@en .

knobit:K-823 rdfs:label "Recognises a drop script used as a rollback"@en .

knobit:K-824 rdfs:label "Recognises an environment baked into the script"@en .

knobit:K-825 rdfs:label "Recognises SQL reviewed without being run"@en .

knobit:K-826 rdfs:label "Recognises undetected drift between database and model"@en .

knobit:K-827 rdfs:label "Recognises a time zone dropped from a timestamp"@en,
        "Recognises an event timestamp stored without a time zone"@en .

knobit:K-828 rdfs:label "Recognises a business date stored with a time of day"@en .

knobit:K-851 rdfs:label "Explains generated artefacts and their single source of truth"@en .

knobit:K-852 rdfs:label "Explains SQL dialect differences"@en .

knobit:K-853 rdfs:label "Explains currency minor units"@en .

knobit:K-854 rdfs:label "Explains time zones in timestamps and business dates"@en .

knobit:K-855 rdfs:label "Explains collation and case or accent sensitivity"@en .

knobit:K-856 rdfs:label "Explains access design for classified data"@en .

knobit:K-857 rdfs:label "Explains schema migration and rollback"@en .

knobit:K-858 rdfs:label "Explains environment-independent deployment"@en .

knobit:K-859 rdfs:label "Explains testing DDL by execution and detecting drift"@en .

outcome:LO-6 rdfs:label "Designs a physical data model for the target platform without introducing anomalies"@en,
        "Kujundab sihtplatvormile füüsilise andmemudeli uusi anomaaliaid tekitamata"@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 .