Knobit of Data modelling · K-507 · Skill

Recognises attributes held as name-value rows

What it means

An entity whose rows are name-value pairs holding what should be attributes. Each property loses its type, domain, optionality and relationships, and nothing stops two rows giving the same property two values. A specific form of row 30.

How it is assessed

Flags the deficient case and passes the acceptable one. Deficient: Account Property (Account, Property Name, Property Value), with account status, interest rate type and overdraft limit all as Text Acceptable: Explicit attributes on Account or its subtypes (rows 16, 19). If the properties are open-ended by business decision (a product catalogue where the business adds product features weekly), record that with a waiver, and keep a Property Definition entity holding each property's type, unit and value set

Builds on

Explains attribute domainsK-562 · Knowledge

Needed by

None