I4 (2 points)
https://knobit.org/id/task/physical-model/I4
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/I4 |
| rdfs:label | I4 (2 points) en |
| schema:hasPart | physical-model I4a: FLOAT for money |
| schema:hasPart | physical-model I4b: sentinel date replaced |
| schema:identifier | I4 |
| schema:position | 7 |
| schema:text | Datatypes, 1 each: (a) requested_amount and income are FLOAT (or DOUBLE), which cannot hold money exactly - changed to NUMBER/DECIMAL with a scale; (b) decision_date uses 9999-12-31 for an undecided application, a sentinel that every date filter and every MAX silently includes - replaced by NULL with the meaning recorded, or by a status column. en |
Used by
| has question | Loan application physical model on Snowflake (physical design anomaly skills) |
|---|---|
| schema:isPartOf | physical-model I4a: FLOAT for money |
| schema:isPartOf | physical-model I4b: sentinel date replaced |