@prefix dcterms: <http://purl.org/dc/terms/> .
@prefix edu: <https://knobit.org/def/> .
@prefix knobit: <https://knobit.org/id/knobit/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .
@prefix register: <https://knobit.org/id/register/> .
@prefix schema: <https://schema.org/> .
@prefix skos: <http://www.w3.org/2004/02/skos/core#> .

knobit:K-815 a edu:Knobit ;
    rdfs:label "Money in binary floating point (generated DDL)"@en ;
    dcterms:identifier "K-815" ;
    dcterms:license <https://creativecommons.org/licenses/by/4.0/> ;
    dcterms:source "Review checklist 05-ddl, row 15; IEEE 754; ISO 9075"@en ;
    skos:definition "`FLOAT`, `REAL` or `DOUBLE PRECISION` on anything that is money — an amount, a balance, a rate applied to money, a quantity that is summed and then reconciled. 0.01 has no exact binary representation, so the total depends on the order of the rows and the ledger never agrees twice."@en ;
    skos:prefLabel "Money in binary floating point (generated DDL)"@en ;
    edu:actionVerb "Recognises"@en ;
    edu:assessmentCriterion "Flags the deficient case and passes the acceptable one. Deficient: `instructed_amount DOUBLE PRECISION`; the daily settlement total differs from core banking by a few cents, and by a different few cents after the table is repartitioned Acceptable: `DECIMAL(14,2)` as the sample model has it, and `DECIMAL`/`NUMERIC` for every amount and for `loan_interest_rate` (e.g. `DECIMAL(7,5)`). `FLOAT` only for a statistic nobody reconciles, such as a propensity score"@en ;
    edu:assessmentMethod "skill-tests task: Generated DDL review, Postgres and Snowflake (DDL review skills)"@en ;
    edu:contextFunction <https://knobit.org/def/contextFunction/resultEvaluation> ;
    edu:creationMethod <https://knobit.org/def/creationMethod/aiGeneratedHumanEdited> ;
    edu:expectedResult "A finding that names the defective generated DDL element and the defect"@en ;
    edu:graphRelevance <https://knobit.org/def/graphRelevance/learnerState>,
        <https://knobit.org/def/graphRelevance/taskSelection> ;
    edu:knobitType <https://knobit.org/def/knobitType/skill> ;
    edu:targetObject "generated DDL"@en ;
    schema:creativeWorkStatus "superseded" ;
    schema:isPartOf register:data-modelling ;
    schema:supersededBy knobit:K-618 .

edu:Knobit rdfs:label "Knobit"@en,
        "Knobit"@et .

knobit:K-618 rdfs:label "Recognises binary floating point used for an exact quantity"@en .