Module 4 — Normal Forms: Detecting Partial Dependencies in Composite-Key Tables
How to play: Each item on the conveyor belt shows an attribute from a composite-key table.
Click the item to select it, then click the correct bin to sort it —
or click the bin directly while an item is selected.
Sort each attribute based on whether it has a partial dependency (depends on only part of the composite key)
or a full dependency (depends on the entire composite key).
Don't let items fall off the end of the belt!
✅ Correct:0
❌ Missed:0
📦 Remaining:0
Progress
📋 Current Table Reference
Loading...
Composite PK attribute
Full dependency (→ whole key)
Partial dependency (→ part of key)
▶ Conveyor Belt — items move left to right →
⚠️
Partial Dependency
Attribute depends on only part of the composite key
(violates 2NF — should be moved to a separate table)
Sorted: 0
✅
Full Dependency
Attribute depends on the entire composite key
(satisfies 2NF — stays in this table)
Sorted: 0
0
Correct
0
Missed / Wrong
0%
Accuracy
💡 Tip: Click an item on the belt, then click a bin — or press 1 for Partial / 2 for Full