This case Study is not solved.
Expired Chrome File Edit View History Bookmarks People Window Help 41% D Mon 1:47 PM Andrew Jones a welcome Flashuine x D Homework Assignments Mis x Database Lesson #4 of 8 x C Chegg Study I Guided Solutio x Database Processing 13th Edi x Andrew Secure https: www.Transtutors.com/ helplDatabase-Processing-13th-edition-chapter-5-problem-1TCS-solution-9780133401875 homework E Apps Bookmarks Best Shots Wrestling Gaming Links mpo ed work c5 Design Tutorials IL.. Podcasts pickles i… Andrew Sampson A Autodesk 123D De Chegg Study TEXTBOOK SOLUTIONS EXPERT Q&A Database Processing (13th Edition) Bookmark Show all steps: O ON E Chapter 5, Problem 1Tcs Chapter 5 Problem The Queen Anne Curiosity Shop wants to expand its database applications beyond the 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 modified to include an inventory system that will allow multiple units of an item to be stored under one ltemID. The system should allow for a quantity on hand, a quantity on order, and an order due date. lftire identical item is stocked by multiple vendors, the item should be orderable from any of these vendors. The SALE ITEM table should then include Quantity and Extended Price 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 shown in Chapter 3’s The Queen Anne Curiosity Shop Project Questions. Use the IE Crows Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum 1594 doc show All X REQ-ENG pptx