Assume a computer merchant with two store locations uses the following global schema for a relational database that keeps information about items at each store Item(item#, itemName, supplier, unitCost) Store(storeName, address, manager, telephone) Stock(itemNo, store, qoh) Each of the two stores serves customers in its own geographical area, but if an item is out of stock quantity on hand qoh 0), the manager can obtain the item from another store. Each of the items comes from only one supplier, but there are different suppliers for different items The database is distributed among the two locations A and B. The Stock information is partitioned, with each store having only the records of its own items, the Store data is replicated at each location without partitioning, but the Item table is located only at the main location, which is location A. Thus we have the following allocation: Location A: Item, Store, Stock_A Location B: Store, Stock_B a. Provide the allocation schema by giving the attribute list and guard conditions for all tables/fragments (use table names given in the allocation above) Assume a computer merchant with two store locations uses the following global schema for a relational database that keeps information about items at each store Item(item#, itemName, supplier, unitCost) Store(storeName, address, manager, telephone) Stock(itemNo, store, qoh) Each of the two stores serves customers in its own geographical area, but if an item is out of stock quantity on hand qoh 0), the manager can obtain the item from another store. Each of the items comes from only one supplier, but there are different suppliers for different items The database is distributed among the two locations A and B. The Stock information is partitioned, with each store having only the records of its own items, the Store data is replicated at each location without partitioning, but the Item table is located only at the main location, which is location A. Thus we have the following allocation: Location A: Item, Store, Stock_A Location B: Store, Stock_B a. Provide the allocation schema by giving the attribute list and guard conditions for all tables/fragments (use table names given in the allocation above)