I1 (2 points)
https://knobit.org/id/task/physical-model/I1
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/physical-model/I1 |
| rdfs:label | I1 (2 points) en |
| schema:hasPart | physical-model I1: unenforced constraints kept and checked |
| schema:identifier | I1 |
| schema:position | 4 |
| schema:text | Snowflake enforces no primary key, unique constraint or foreign key, 1 point each: (a) the declared constraints are kept as documentation for the optimiser and the BI layer rather than deleted; (b) each one the design relies on is named as needing a data quality rule, with uniqueness and referential integrity called out specifically. en |
Used by
| has question | Loan application physical model on Snowflake (physical design anomaly skills) |
|---|---|
| schema:isPartOf | physical-model I1: unenforced constraints kept and checked |