Skip to main content

Practice ยท 3 of 3

Normalization Checker

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.

Difficulty: intermediate

Back to lesson: Practice: Schema Design โ€” Practice