Question: Case Study 2 Instructions: Using the schema provided below and using SQL to create and populate the fragments for this distributed database. Item (itemNo, itemName,
Case Study 2 Instructions: Using the schema provided below and using SQL to create and populate the fragments for this distributed database. Item (itemNo, itemName, supplier, unitCost) Store (storeName, state, manager, telephone) Stock (itemNo, storeName, qtyOnHand, reorderPoint) This company has 20 stores that stock about 15,000 different items. Each item comes from only one supplier, but there are different suppliers for different items. The database currently keeps track of what items are in what store, what items have been reordered at each store, and the reorder point (the minimum number of each item that each store wishes to keep stock). This information is currently stored in a centralized database. Use SQL to create and populate the fragments for this distributed database.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
