Recognises a connection trap
A fact inferred from a path of two relationships that never recorded it.
Can AI do this?
Not tested yet
No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.
What it looks like in practice
Expected result: The path and the fact it is wrongly read to state
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
Also known as: Connection trap (logical model)
Related knobits
Builds on
- K-569 Explains the connection, fan and chasm traps
- K-559 Explains join dependency and fifth normal form
All 56 knobits of Derive the logical data model.
Source: Review checklist 05-logical, row 23; Codd 1970 §2.1.4