Read the following instructions VERY CAREFULLY before proceeding! Instructions: 1. Read each question carefully so you UNDERSTAND CLEARLY what is being asked. 2. For Question 1, you should answer a total of FOUR (4) questions: At Site C: i. Answer either query a, b or c – only one (1)! ii. Answer either query d, or e – only one (1)! At Site A: iii. Answer either query f, g, or h – only one (1)! At Site B: iv. Answer either query i or j – only one (1)! 3. For Question 2, you should have describe the fragmentation related to ONLY ONE (1) of the database table for Part a – either CUSTOMER or INVOICE: Be SURE that your paper has NO MORE than the one (1) description required! This instruction is only related to Question2, Part a. 4. For Question 2, you should have only ONE (1) fragment sample table for Part c: Be SURE that your paper has NO MORE than the one (1) required! This instruction is only related to Question2, Part c. 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.
Read the following instructions VERY CAREFULLY before proceeding!
Instructions:
1. Read each question carefully so you UNDERSTAND CLEARLY what is being asked.
2. For Question 1, you should answer a total of FOUR (4) questions:
At Site C:
i. Answer either query a, b or c – only one (1)!
ii. Answer either query d, or e – only one (1)!
At Site A:
iii. Answer either query f, g, or h – only one (1)!
At Site B:
iv. Answer either query i or j – only one (1)!
3. For Question 2, you should have describe the fragmentation related to ONLY ONE (1) of the
Be SURE that your paper has NO MORE than the one (1) description required!
This instruction is only related to Question2, Part a.
4. For Question 2, you should have only ONE (1) fragment sample table for Part c:
Be SURE that your paper has NO MORE than the one (1) required!
This instruction is only related to Question2, Part c.
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.
Step by step
Solved in 3 steps
