Database Systems
Data Model Design
This homework will focus on concepts related to the creation of a data model.
- You have been hired to help develop a database for the sales system for a new store that will sell board games. The system should support the following:
- Inventory management (both what games are in stock for a given store location and what games are available for order)
- Customer management (for sales and marketing purposes)
- Order management (orders that have been placed by customers, both for delivery and for pick-up in a location)
(a) (12 points) Draw an Entity-Relationship diagram for your system.
(b) (8 points) Convert your Entity-Relationship diagram into a relational schema
