knobit.org

Loan application physical model on Snowflake (physical design anomaly skills)

edu:Task

https://knobit.org/id/task/physical-model

Also as Turtle · JSON-LD · RDF/XML

assesses learning outcomeDerives a normalised logical data model and traces anomalies to their causes
assesses learning outcomeDesigns a physical data model for the target platform without introducing anomalies
assesses learning outcomeGenerates DDL per target dialect and reviews it against model, engine, data and deployment
dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
has questionC1 (3 points)
has questionC2 (3 points)
has questionC3 (2 points)
has questionI1 (2 points)
has questionI2 (2 points)
has questionI3 (2 points)
has questionI4 (2 points)
has questionI5 (2 points)
has questionQ1 (2 points)
has questionQ2 (2 points)
owl:sameAshttps://bitbucket.org/reffa/ontology/id/task/physical-model
rdfs:commentIf C2 scores zero, the total is capped at 13. en
rdfs:labelLoan application physical model on Snowflake (physical design anomaly skills) en
related topicData modelling and design (DAMA-DMBOK2 chapter 5)
schema:descriptionGraded on 10 criteria, 22 points in total. en
schema:identifierphysical-model
schema:urlhttps://bitbucket.org/reffa/skill-tests/src/master/tests/physical-model/test.md

Used by

has taskTests of the data-modelling skill