Normalise or Denormalise?

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

Your orders table copies the customer's name and address into every order row. A colleague says that's bad design, but another says it makes reports fast. Explain normalisation and denormalisation and when each is right, including for this case.

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 →