The Queen Anne Curiosity Shop wants to expand its database applications beyond It, current recording of sales.
Question:
The Queen Anne Curiosity Shop wants to expand its database applications beyond It, current recording of sales. The company still wants to maintain data on customers. Employees, vendors, sales, and items, but it wants to (a) modify the way it handles inventory and (b) simplify the storage of customer and employee data. Currently, each item is considered unique, which means the item must be sold as a whole, and multiple units of the item in stock must be treated as separate items in the ITEM table. The Queen Anne Curiosity Shop management wants the database mooned to include an inventory system that will allow multiple units of an item to be stored unyr one ItemID. The system should allow for a quantity on hand, a quantity on order, and an order due date. If the identical Item is stocked by multiple vendors, the item should be orderable from any of these vendors. The SALE ITEM table should then include Ouantty and ExtendedPrice columns to allow for sales of multiple units of an item. The Queen Anne Curiosity Shop management has noticed that some of the fields in CUSTOMER and EMPLOYEE store similar data. Under the current system, when an employee buys something at the store, his or her data has to be reentered into the CUSTOMER table. The managers would like to have the CUSTOMER and EMPLOYEE tables redesigned using subtypes.
A. Draw an E-R data model for The Queen Anne Curiosity Shop database schema show) in Chapter 3. Use the IE Crow's Foot E-R model for your E-R diagrams. Justify the der: sions you make regarding minimum and maximum cardinality.
B. Extend and modify the E-R data model by adding only The Queen Anne Cunositx Shop's inventory system requirements. Use the 1E Crow's Foot E-R model for your E. diagrams. Create appropriate identifiers and attributes for each entity. Justify the deer sions you make regarding minimum and maximum cardinality.
C. Extend and modifi, the BR data model by adding only The Queen Anne Curioty Shops need for more efficient storage of CUSTOMER and EMPLOYEE data Use the 1E Crow's Foot E-R model for your E-R diagrams. Create appropriate identifiers and attributes for each entity. Justify the decisions you make regaiding minimum and maximum radially.
D. Combine the E-R data models from parts B and C to meet all of The Queen Anne Curiosity Shop's new requirements, making additional modifications, as needed. Us the IE Crow's Foot BR model for your BR diagrams.
E. Describe how you would go about validating your data model in part D.
Expert Answer:
A Here one customer can buy any number of productsMany to One relationship exists One product may be ... View the full answer
