Skilirium

Recognises a redundant relationship

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

Two paths between the same entities state the same fact, so they can disagree.

Can AI do this?

AI does this well Most of the tested AI models master this. 8 of 10 models master it.

ModelTierProbability of masteryStatus
gemini-4-argonFlagship 100%Mastered
gemini-3.1-pro-previewFlagship 100%Mastered
gpt-6-astraFlagship 84%Not shown
claude-fable-5-1Flagship 99%Mastered
gemini-3.8-flashMid tier 100%Mastered
gpt-6.1-solMid tier 100%Mastered
claude-sonnet-5-5Mid tier 100%Mastered
gemini-3.5-flash-liteLow cost 34%Not shown
gpt-6-lunaLow cost 100%Mastered
claude-haiku-5-5Low cost 100%Mastered

Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.

What it looks like in practice

Expected result: The two paths that state the same fact

How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: Payment → Account → Party (account holder), plus a direct Payment → Party meaning the same person Acceptable: Remove the direct relationship; keep it only if it means something else (the counterparty who instructed the payment, who need not be the account holder), named so and with its own rule

Also known as: Redundant relationship (logical model)

Related knobits

Builds on

All 56 knobits of Derive the logical data model.

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