The Mega Supply Corporation has three divisions Commercial Products, Consumer Products. and Corporate Offices, which are located in Hatfield SC, Palo Alto. CA: and Tulsa OK, respectively. The Commercial Products division deals exclusively in sales of industrial products and supplies to business organizations The Consumer Products division sells non industrial products to private consumers Both divisions have dedicated inventory warehouses at their respective locations in Hatfield and Palo Alto Because of the dissimilar nature of the commercial and consumer division product lines, they do not share customers or vendors. Currently Mega Supply uses a centralized database, which is located at their Corporate Division in Tulsa Some relevant database tables and attributes are presented in the figure designated
Problem 1
When customers contact their respective sales division, the sales clerk logs into the corporate data base, checks credit determines product availability, and creates a sales invoice. The corporate office typically bills the customer within 3 or 4 days and extends terms of net 30. Inventory control, AR processing, cash receipts, purchases from vendors and AP processing, and cash disbursements are performed by the corporate office.
Due to Mega's rapid growth, the company has seen a significant increase in sales and purchase transactions, which has resulted in excessive delays in processing transactions from the central database Since customer service, including raped response to customer inquiries and sales order processing is a cornerstone of Mega's business model these delays are unacceptable.
Required
Mega wants to improve response time by distributing some parts of the corporate database while keeping other parts it centralized
A) Develop a schema for distributing Mega Supply Corporations database. Add new tables and attributes as needed but limit the schema to the tables needed to support sales, cash receipts. Purchases/AP, and cash disbursements In your schema, indicate whether tables are centralized, replicated, or partitioned
B) Explain how the new system will operate.

Transcribed Image Text:

PROBLEM Customer Table Cuslomer Cusluner Class Stipping Line uf Credit Address Sales Invcice (AR) Sales Iivuice Num Cusluner Irnvuice Invuice Date Number Inventory Table Product Num Quantity on Hand Unit Cost Vendor Class Vendor Invoice (AP) Vendor Vendor Invoice Num Invoice Amount Invoice Date Vendor Table Vendor Vendor Num l el Numbcr Note: Customer Class: Value1 Commercial, Value 2 Cansumer Inventory Class: Value 1 = Industial product, Value 2= Ca sumer poduct