Week 3 - Create Database and ERD
Learning Objectives
After today's class, you should be able to:
- Create a database using MySQL Workbench, reverse engineer an ERD, and modify the relationships to reflect the business rules for optionality.
- Create an ERD using QuickDBD and Export the SQL to create the database.
Class Agenda
- Create Database and ERD Demo
[5 min]Break Optional- In Class Time for CP1 Create Database
Task List
- Complete and Submit CP1 Create Database by EOD
- Complete and Submit HW2 Create Database and ERD
Note
Crow's Foot notation ERD is NOT required for CP1.