Apr 09: Build and populate a database

Learning Objectives

After today's class, you should be able to:

• Review EER and relational model rules to revise HW4
• Use dbdiagram.io to create SQL DDL and build a database
• Use SQL scripts and the Python faker module to create data

Lesson Outline

• Review common mistakes in EER and relational models - slides
• Introduce HW7

Activity

• Work with your team to revise your HW4 models

  • Correct any errors
  • Be sure the model structure will support the sample queries
  • Look back at the activities on Mar 10 and Mar 12 to help build and populate the database

• Instructions for teams who built their relational model in MySQL Workbench

Your To-Do List

• Complete HW6
• Make progress on HW7