Assignment : The Entity Relationship Diagram
Case Study
The goal of this exercise is for you to begin to understand how the tables in a database relate. For this assignment, you will need to create an entity relationship diagram (ERD)
Consider the data tables you will need in order to bring the Broadway Cafe into the 21st century. You know you have customers and orders and inventory (you will need to think about more things you will need - be creative!). Each of them may require numerous tables (as per the examples given).
Think about the fields needed in each table. For example, your customer database needs:
?names
?addresses
?a customer ID
?customer status (active, inactive, preferred, etc)
?what else?
How about your orders table? What else might you need? Your ERD must clearly label primary keys and foreign keys, and show their relationships so that they are easy to follow.