Practice · 3 of 3

Normalization Checker

CHALLENGE

Difficulty: intermediate+25 XP

Write isNormalized(rows) — rows are task rows; return false when any row has an authorName alongside authorId (denormalized duplicate — the name belongs to users), true otherwise. Write normalize(rows, users) producing normalized rows: drop authorName, keep authorId; users is the lookup you would join to later.

Press Submit to check your solution.

Back to lesson: Practice: Schema Design — Practice