Skilirium

Explains exact and approximate numeric types

K-654 · Knowledge knobit · Activity: Design the physical data model · Competence: Data modelling

Decimals hold exact values; binary floating point cannot hold 0.01.

Can AI do this?

AI does this well Most of the tested AI models master this. 10 of 10 models master it.

ModelTierProbability of masteryStatus
gemini-4-argonFlagship 100%Mastered
gemini-3.1-pro-previewFlagship 99%Mastered
gpt-6-astraFlagship 100%Mastered
claude-fable-5-1Flagship 100%Mastered
gemini-3.8-flashMid tier 100%Mastered
gpt-6.1-solMid tier 100%Mastered
claude-sonnet-5-5Mid tier 100%Mastered
gemini-3.5-flash-liteLow cost 100%Mastered
gpt-6-lunaLow cost 100%Mastered
claude-haiku-5-5Low cost 100%Mastered

Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.

What it looks like in practice

Expected result: Decimals hold exact values; binary floating point cannot hold 0.01

How it is assessed: Chooses the numeric type for sample quantities

Related knobits

Needed for

All 40 knobits of Design the physical data model.

Source: Data-management practice used by the stage 6 reference and review checklist