Your task is to construct an E-R diagram and the resulting normalized tables to solve the scenario below. You should present your results beginning with a Conceptual ERD (your initial impression of the scenario) and the corresponding Dependency Diagrams. From this continue to normalize until you have a complete set of related tables.
Your task is to develop the database design for a business that has multiple stores. They would like to be able to track the sale of products to customers, as well as inventory level per store.
Data must be captured to identify customers (name, address, phone number, email), products (price, type, manufacturer), and store (name, address).
They also need to report on things like:
Sales per store
Sales per product
Stock levels
HINTS:
—Begin by looking at the customer.
— Customer …….. Products (1:M)
—Take a top-down approach; start with E-R and move to attribute definition
—Look for partial and transitive dependencies
—Remember to make attributes as atomic as possible
—Feel free to add any attributes you think are necessary
Requirements:
In this assignment, you are responsible for the following:
—E-R diagram based on your initial view of the database
—Dependency diagram(s) showing your entity definition
—Entity definition; list all fields, primary key, and foreign keys
—E-R diagram based upon your final (“‘normalized view”) of the database
0 comments