Knobit of Data modelling · K-505 · Skill

Recognises an attribute holding several facts

What it means

An attribute whose value is parsed: an aggregate the business sorts or matches by part, or a code whose segments carry meaning. When the meaning of a segment changes, every value is wrong.

How it is assessed

Flags the deficient case and passes the acceptable one. Deficient: Account Identifier (the IBAN) as one Text although reports group by bank identifier; product code CUR-TLN-2026-0042 parsed for product family, branch and year Acceptable: Country code, check digits, bank identifier and account number as separate attributes; Product Code kept opaque, with product family, branch and year as attributes of their own

Builds on

Explains first normal formK-554 · Knowledge
Explains attribute domainsK-562 · Knowledge

Needed by

None