[Solved] CSCI 4380 Homework 3

Database Systems

Data Model Design

This homework will focus on concepts related to the creation of a data model.

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