The following describe the data structure and constraints that 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 2a. c. On the first of each month, an annual subscription INVOICE is printed and sent to each customer whose subscription is due for renewal. The INVOICE entity contains a REGION attribute to indicate the customer’s state of residence (FL, SC, GA, TN). d. The table fields are as below: CUSTOMER (CUS_NUM, CUS_NAME, CUS_ADDRESS, CUS_CITY, CUS_STATE, CUS_ZIP, CUS_SUBSDATE) INVOICE (INV_NUM, INV_REGION, CUS_NUM, INV_DATE, INV_TOTAL) The company 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 management at company headquarters, however, will have access to customer and invoice data to generate annual reports and to issue ad hoc queries, such as: List all current customers by region. List all new customers by region. Report all invoices by customer and by region. Related Questions: Given the scenario and the requirements described above, answer the following: a. Describe the type of data fragmentation needed for either the CUSTOMER or INVOICE table and say what nodes will result from fragmenting. Explain in detail -- use a diagram if that helps. b. State what transparency features are required and not required of the fragmented system. c. Design any ONE (1) database fragment that will result from the fragmentation you specified above in part a. For the fragment, do the following: A. State: a. Whether it is a fragment of the INVOICE or CUSTOMER table b. Its node name c. Its node location B. Show an example of your fragment design by developing a sample table showing: a. All attributes in the fragment b. Three (3) rows of sample data in the fragment.
The following describe the data structure and constraints that 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 2a.
c. On the first of each month, an annual subscription INVOICE is printed and sent to each customer
whose subscription is due for renewal. The INVOICE entity contains a REGION attribute to indicate
the customer’s state of residence (FL, SC, GA, TN).
d. The table fields are as below:
CUSTOMER (CUS_NUM, CUS_NAME, CUS_ADDRESS, CUS_CITY, CUS_STATE, CUS_ZIP,
CUS_SUBSDATE)
INVOICE (INV_NUM, INV_REGION, CUS_NUM, INV_DATE, INV_TOTAL)
The company 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 management at company
headquarters, however, will have access to customer and invoice data to generate annual reports and to
issue ad hoc queries, such as:
List all current customers by region.
List all new customers by region.
Report all invoices by customer and by region.
Related Questions:
Given the scenario and the requirements described above, answer the following:
a. Describe the type of data fragmentation needed for either the CUSTOMER or INVOICE table
and say what nodes will result from fragmenting. Explain in detail -- use a diagram if that helps.
b. State what transparency features are required and not required of the fragmented system.
c. Design any ONE (1)
above in part a. For the fragment, do the following:
A. State:
a. Whether it is a fragment of the INVOICE or CUSTOMER table
b. Its node name
c. Its node location
B. Show an example of your fragment design by developing a sample table showing:
a. All attributes in the fragment
b. Three (3) rows of sample data in the fragment.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images
