Production Schema Step 4: Normalize It

Take the flat signups table from this module and design it properly: people, venues, workshops and signups, with the right keys and constraints. Write the migration queries that would move the flat data into your design, including your decision about the two spellings of the venue and how many rows it affects. Then check your own schema from the SQL course against the three forms and fix anything that fails, or write down why the exception is deliberate.

SANKOFA SANDBOX
loading editor…
Your turn → Work through it step by step. This is a piece of the course project, not a throwaway exercise.

Built it in both languages?

Mark it done once your Python and JavaScript versions both run correctly. Honesty here is what makes the dashboard useful to you.

← BackNext: Module 5: Relationships and Diagrams →