Overview

This assignment is designed to help you understand how to model a relational database.

Assignment

$1.$ Using the data in the Cake Order Database, decide what tables of data could be created, and what fields would be included in the tables.

$2.$ Identify what field would serve as the primary key for the tables.

$3.$ Create an entity relationship diagram showing the tables $($with fields$)$ and relationships among the tables.

$4.$ What other data could be included in this database? What benefits are there from organizing the data this way as opposed to in an Excel file?

Submit your answers to the designated Submissions folder in FOL by this Sunday evening