knobit.org

I13 (1 points)

edu:Question

https://knobit.org/id/task/dm-physical-postgres/I13

Also as Turtle · JSON-LD · RDF/XML

dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
owl:sameAshttps://bitbucket.org/reffa/ontology/id/task/dm-physical-postgres/I13
rdfs:labelI13 (1 points) en
schema:hasPartdm-physical-postgres I13: null meaning no ATM limit
schema:identifierI13
schema:position17
schema:textNull with a business meaning: card.daily_atm_limit_amount uses NULL to mean no limit, while account_overdraft_terms.overdraft_limit_amount uses NULL to mean not yet decided; the same null means two different things and an unlimited card cannot be told from one whose limit is unknown (BR-309). Fixed by stating unlimited explicitly (an indicator or a limit type, with a check that the amount is null exactly when unlimited) and keeping NULL for unknown only. Replacing NULL with a large number scores 0. en

Used by

has questionRetail banking servicing schema on PostgreSQL (transactional physical design anomaly skills)
schema:isPartOfdm-physical-postgres I13: null meaning no ATM limit