Chapter 12 Assignment - 2. The following data structure and...

2. The following data structure and constraints exist for a magazine publishing company.
a. The company publishes one regional magazine each in Florida (FL), South Carolina (SC),
Georgia (GA), and Tennessee (TN).
b. The company has 300,000 customers (subscribers) distributed throughout the four states listed
in Part a.
c. On the first of each month an annual subscription INVOICE is printed and sent to all customers
whose subscription is due for renewal. The INVOICE entity contains a REGION attribute to
indicate the state (FL, SC, GA, TN) in which the customer resides:
CUSTOMER (CUS_NUM , CUS_NAME, CUS_ADDRESS, CUS_CITY, CUS_STATE,
CUS_SUB_DATE)
INVOICE (INV_NUM , REG_CODE, CUS_NUM, INV_DATE, INV_TOTAL)
The company's management is aware of the problems associated with centralized management
and has decided that it is time to decentralize the management of the subscriptions in its four
regional subsidiaries. Each subscription site will handle its own customer and invoice data. The
company's management, however, wants to have access to customer and invoice data to generate