Generated DDL review, Postgres and Snowflake (DDL review skills)
https://knobit.org/id/task/ddl-review
Also as Turtle · JSON-LD · RDF/XML
| assesses learning outcome | Designs a physical data model for the target platform without introducing anomalies |
|---|---|
| assesses learning outcome | Generates DDL per target dialect and reviews it against model, engine, data and deployment |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| has question | C1 (3 points) |
| has question | C2 (3 points) |
| has question | C3 (2 points) |
| has question | I1 (2 points) |
| has question | I2 (2 points) |
| has question | I3 (2 points) |
| has question | I4 (2 points) |
| has question | I5 (2 points) |
| has question | Q1 (2 points) |
| has question | Q2 (2 points) |
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/ddl-review |
| rdfs:comment | If C1 scores zero, the total is capped at 13. en |
| rdfs:label | Generated DDL review, Postgres and Snowflake (DDL review skills) en |
| related topic | Data modelling and design (DAMA-DMBOK2 chapter 5) |
| schema:description | Graded on 10 criteria, 22 points in total. en |
| schema:identifier | ddl-review |
| schema:url | https://bitbucket.org/reffa/skill-tests/src/master/tests/ddl-review/test.md |
Used by
| has task | Tests of the data-modelling skill |
|---|