@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@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#> .
@prefix schema: <https://schema.org/> .

<https://knobit.org/id/task/physical-model> a edu:Task ;
    rdfs:label "Loan application physical model on Snowflake (physical design anomaly skills)"@en ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    rdfs:comment "If C2 scores zero, the total is capped at 13."@en ;
    owl:sameAs <https://bitbucket.org/reffa/ontology/id/task/physical-model> ;
    edu:assessesLearningOutcome outcome:LO-5,
        outcome:LO-6,
        outcome:LO-8 ;
    edu:hasQuestion <https://knobit.org/id/task/physical-model/C1>,
        <https://knobit.org/id/task/physical-model/C2>,
        <https://knobit.org/id/task/physical-model/C3>,
        <https://knobit.org/id/task/physical-model/I1>,
        <https://knobit.org/id/task/physical-model/I2>,
        <https://knobit.org/id/task/physical-model/I3>,
        <https://knobit.org/id/task/physical-model/I4>,
        <https://knobit.org/id/task/physical-model/I5>,
        <https://knobit.org/id/task/physical-model/Q1>,
        <https://knobit.org/id/task/physical-model/Q2> ;
    edu:relatedTopic <https://knobit.org/id/topic/dmbok2-data-modelling> ;
    schema:description "Graded on 10 criteria, 22 points in total."@en ;
    schema:identifier "physical-model" ;
    schema:url <https://bitbucket.org/reffa/skill-tests/src/master/tests/physical-model/test.md> .

edu:Task rdfs:label "Task"@en,
        "Ülesanne"@et .

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 .

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 .

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

<https://knobit.org/id/task/physical-model/C1> rdfs:label "C1 (3 points)"@en .

<https://knobit.org/id/task/physical-model/C2> rdfs:label "C2 (3 points)"@en .

<https://knobit.org/id/task/physical-model/C3> rdfs:label "C3 (2 points)"@en .

<https://knobit.org/id/task/physical-model/I1> rdfs:label "I1 (2 points)"@en .

<https://knobit.org/id/task/physical-model/I2> rdfs:label "I2 (2 points)"@en .

<https://knobit.org/id/task/physical-model/I3> rdfs:label "I3 (2 points)"@en .

<https://knobit.org/id/task/physical-model/I4> rdfs:label "I4 (2 points)"@en .

<https://knobit.org/id/task/physical-model/I5> rdfs:label "I5 (2 points)"@en .

<https://knobit.org/id/task/physical-model/Q1> rdfs:label "Q1 (2 points)"@en .

<https://knobit.org/id/task/physical-model/Q2> rdfs:label "Q2 (2 points)"@en .

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