Recognises one decimal scale for every currency
https://knobit.org/id/knobit/K-816
Also as Turtle · JSON-LD · RDF/XML · AI benchmark on Skilirium
| Context functions | Result evaluation |
|---|---|
| Knobit creation methods | AI generated, human edited |
| Knobit types | Skill |
| LCG purposes | Assessing the learner's knowledge or skill state |
| LCG purposes | Selecting an assessment task or learning activity |
| action verb | Recognises en |
| applies knowledge | Explains currency minor units |
| assessment criterion | Flags the deficient case and passes the acceptable one. Deficient: `fact_payment.instructed_amount DECIMAL(14,2)` with `account_currency_code` ranging over ISO 4217; a KWD payment of 12.345 is stored as 12.35 and the original instruction can no longer be reproduced Acceptable: Scale set to the widest minor unit in scope (`DECIMAL(16,3)`), the per-currency minor-unit digits held in the currency reference table, and a DQ rule that an amount's minor units match its currency. Or the single-currency scope stated in the column `comment`, so the next reviewer knows `2` was a decision en |
| assessment method | skill-tests task: Generated DDL review, Postgres and Snowflake (DDL review skills) en |
| conforms to profile | https://oppekava.edu.ee/a/Knobitite_kirjeldamise_ja_seostamise_reeglid#LCG-KNOBIT-0.1 |
| dcterms:identifier | K-816 |
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
| dcterms:source | Review checklist 05-ddl, row 16; ISO 4217 en |
| depends on knobit | Recognises a physical domain differing from the logical domain |
| expected result | The column and the scale its currencies need en |
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/knobit/data-modelling/08-ddl/16 |
| rdfs:label | Recognises one decimal scale for every currency en |
| schema:creativeWorkStatus | accepted |
| schema:isPartOf | Data modelling (DAMA-DMBOK2) |
| skos:altLabel | One scale for every currency (generated DDL) en |
| skos:definition | `DECIMAL(n,2)` on an amount column in a table that is not single-currency. ISO 4217's minor-unit table is not a constant 2: JPY has 0, KWD and BHD have 3. Two decimals silently round a dinar instruction and store two meaningless zeros on a yen one. en |
| skos:prefLabel | Recognises one decimal scale for every currency en |
| target object | amount column in a multi-currency table en |
Used by
| includes knobit | Generates DDL per target dialect and reviews it against model, engine, data and deployment |
|---|---|
| requires knobit | Generate and review DDL |