Skip to content

Latest commit

 

History

History
19 lines (13 loc) · 775 Bytes

QA_PREP_EXERCISES.md

File metadata and controls

19 lines (13 loc) · 775 Bytes
Raw

Prep exercise week 3

As a preparation step for the upcoming Q&A, you need to work on the following exercise, which is based on the prep exercise of the previous week.

Exercise

Last week you created an ERD for the database for storing food recipes. How can you normalize your database based on what you learned this week? In particular, try answering following questions and provide table definitions from the last week and this week to explain the changes.

  • Was your database already in 2NF / 3 NF?
  • What changes did you have to do to normalize your database?

Discussion

  • If you want to add thousands of recipes to your database, what challenges do you foresee?
  • Try to write answers to these questions in text, provide queries and commands when necessary.