Recognises a fan trap

K-524 · Skill knobit · Activity: Derive the logical data model · Competence: Data modelling

Two one-to-many relationships fan out from the same entity, and a question about how their many sides relate cannot be answered.

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 entity with two one-to-many relationships and the question they cannot answer

How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: Branch 1:N Account Manager and Branch 1:N Account: which account manager services which account? Acceptable: Branch 1:N Account Manager 1:N Account, so the path carries the fact

Also known as: Fan trap (logical model)

Related knobits

Builds on

• K-569 Explains the connection, fan and chasm traps

All 56 knobits of Derive the logical data model.

Source: Review checklist 05-logical, row 24; Howe; C&B