Question
2. (10 points) A cosmetic product retailer company needs to create a database to keep track of the information for its business operations. The company
2. (10 points) A cosmetic product retailer company needs to create a database to keep track of the information for its business operations. The company has a web site that posts all its products. The product information includes product ID, product name, description, and unit sale-price. The retailer needs to keep track of information (name, address of contact, phone, email, etc.) of suppliers of products. Each product is from only one supplier, but a supplier may charge differently for the same product at different time depending on the market situation and volume of the product supplied. Some products are developed by the company itself. The company also needs to keep track of customers information, including customer names, their shipping addresses, and the email address. The company creates an account for each customer for identification and analytics. A customer can purchase multiple products with different quantities in one order. The company needs to keep track of information for all orders customers placed, including the order date, invoice number, and information about products purchased in an order such as IDs of products, and quantities, etc. The products are stocked in several warehouses owned by the company. The company also needs to keep track of the the information about each warehouse such as its name, address, manager, telephone, etc.
a. Create an E/R model for this scenario. In your E/R model you need to show the names of entities, names of attributes, keys and the name(s) of relationship(s). Also indicate appropriate maximum and minimum cardinalities (insert its image here).
b. Transform this E/R model into a database design model (a set of tables). Label/indicate keys and foreign keys).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started