2. Using the distributed database described by the diagram below, specify the minimum types of operations...

Transcribed Image Text:

2. Using the distributed database described by the diagram below, specify the minimum types of operations the database must support to perform the following tasks. These operations include remote requests, remote transactions, distributed transactions, and distributed requests. Please see the alt text for the diagram if you are using a screen reader. TABLES FRAGMENTS CUSTOMER PRODUCT INVOICE INV_LINE Site A PROD_A CUSTOMER A. At Site C B. At Site C N/A PROD_A PROD_B o Get a list of all products N/A N/A o Print a customer invoice D. At Site B E. At Site B o Get a list of all customers LOCATION AABBB INVOICE Site C C. At Site A o Create a new order for a customer. This involves creating the invoice and lines as well as updating the product and customer. o Get a list of all the products. Site B INV_LINE PROD_B 2. Using the distributed database described by the diagram below, specify the minimum types of operations the database must support to perform the following tasks. These operations include remote requests, remote transactions, distributed transactions, and distributed requests. Please see the alt text for the diagram if you are using a screen reader. TABLES FRAGMENTS CUSTOMER PRODUCT INVOICE INV_LINE Site A PROD_A CUSTOMER A. At Site C B. At Site C N/A PROD_A PROD_B o Get a list of all products N/A N/A o Print a customer invoice D. At Site B E. At Site B o Get a list of all customers LOCATION AABBB INVOICE Site C C. At Site A o Create a new order for a customer. This involves creating the invoice and lines as well as updating the product and customer. o Get a list of all the products. Site B INV_LINE PROD_B

Answer rating: 100% (QA)

To perform the tasks mentioned using the distributed database described in the diagram the database ... View the full answer