Question: 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

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 model
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
