[solved]-Create Model Database Part Show Tables Diagramas Q38993552
create model database
only do part A , show tables and diagramasYou are going to do Part A only. Do not do the part about the Frequent Cleaner’s Club. Marcia’s Dry Cleaning (MCD) has many customers. The DB has a Customer table that keeps track of all customers. There is an order table that keeps track of all current (open) customer orders. Note that one customer can have zero to many orders. There is an Item table that keeps track of all the items MCD cleans, such as dress, sweater, shirt, pants, coat, etc., and a price for cleaning each of these items. Note that an order can have one to many items. Marcia’s Dry Cleaning Suppose that you have been hired by Marcia’s Dry Cleaning to create a database application to track customers, orders, and items. Marcia also wants to start a Frequent Cleaner’s Club, whereby she will offer a 50 percent discount on every 10th customer order. A. Using your knowledge, create a data model for Marcia’s business. Name each entity. describe its type, and indicate all attributes and identifiers. Name each relationship. describe its type, and specify minimum and maximum cardinalities. B. List any item in your answer to A that you believe should be checked out with Marcia and/or her employees. Show transcribed image text You are going to do Part A only. Do not do the part about the Frequent Cleaner’s Club. Marcia’s Dry Cleaning (MCD) has many customers. The DB has a Customer table that keeps track of all customers. There is an order table that keeps track of all current (open) customer orders. Note that one customer can have zero to many orders. There is an Item table that keeps track of all the items MCD cleans, such as dress, sweater, shirt, pants, coat, etc., and a price for cleaning each of these items. Note that an order can have one to many items.
Marcia’s Dry Cleaning Suppose that you have been hired by Marcia’s Dry Cleaning to create a database application to track customers, orders, and items. Marcia also wants to start a Frequent Cleaner’s Club, whereby she will offer a 50 percent discount on every 10th customer order. A. Using your knowledge, create a data model for Marcia’s business. Name each entity. describe its type, and indicate all attributes and identifiers. Name each relationship. describe its type, and specify minimum and maximum cardinalities. B. List any item in your answer to A that you believe should be checked out with Marcia and/or her employees.
Expert Answer
Answer to create model database only do part A , show tables and diagramas … . . .
OR
