Knobit of Data modelling · K-523 · Skill

Recognises a connection trap

What it means

A fact inferred from a path of two relationships that never recorded it.

How it is assessed

Flags the deficient case and passes the acceptable one. Deficient: Branch authorised for Product, Account is of a Product; "which branch opened this account" answered by joining through the product Acceptable: Account Opening (Account, Branch) records the fact; the inference is valid only under the cyclic rule in row 13

Builds on

Explains the connection, fan and chasm trapsK-569 · Knowledge
Explains join dependency and fifth normal formK-559 · Knowledge

Needed by

None