I3 (2 points)
https://knobit.org/id/task/physical-model/I3
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/I3 |
| rdfs:label | I3 (2 points) en |
| schema:hasPart | physical-model I3: rolled-up subtypes given a discriminator and a check |
| schema:identifier | I3 |
| schema:position | 6 |
| schema:text | The rolled-up subtypes, 1 each: (a) employer_name and business_registration_number are both nullable on DIM_CUSTOMER with nothing saying which applies, so a discriminator column or an equivalent is added; (b) the conditional rule - exactly one of the two is present, by employment type - is recorded as a data quality rule, because Snowflake will not enforce it. en |
Used by
| has question | Loan application physical model on Snowflake (physical design anomaly skills) |
|---|---|
| schema:isPartOf | physical-model I3: rolled-up subtypes given a discriminator and a check |