Spot Normalisation Problems

Talk it through with a coach who asks guiding questions and gives hints until you reach the answer. Pass to mark the challenge as completed.

The problem

  • medium
  • Pro

An orders table stores the customer's name and address on every order and keeps the product names as a comma-separated list in one column. Walk through the first, second and third normal forms and how you'd restructure this.

Talk this problem through with an AI coach

This is a Pro challenge. Sign in with Google, then upgrade to start a voice session.

Start free →