Database Systems
Data Model Design
This homework will focus on concepts related to the creation of a data model.
It is due on Monday February 10 at 15:59pm and should be submitted electronically on the class Submitty site.
1. 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
