1. Specify the number of operations the database must support to perform the query. 2. State what site(s) will be accessed in performing the query. 3. State what types of operations are included in performing the query. For the type: i. Use the following types listed in (a) – (d) below: a. Remote request b. Distributed request. c. Remote transaction d. Distributed transaction ii. Use the table below as a guide also: Use the following summary: Number of Distribution Points Operation Type 1 > 1 Request Remote Distributed Transaction Remote Distributed TABLES FRAGMENTS LOCATION CUSTOMER N/A A PRODUCT PROD_A A PROD_B B INVOICE N/A B INV_LINE N/A B Queries to be analyzed at the sites named: At Site C: a. SELECT * FROM CUSTOMER; b. SELECT * FROM INVOICE WHERE INV_TOTAL < 1000; c. SELECT * FROM PRODUCT WHERE PROD_QOH < 10; d. BEGIN WORK; INSERT CUSTOMER(CUS_NUM, CUS_NAME, CUS_ADDRESS, CUS_BAL) VALUES ('34210','Victor Ephanor', '123 Main St', 0.00); INSERT INTO INVOICE(INV_NUM, CUS_NUM, INV_DATE, INV_TOTAL) VALUES ('986434', '34210', ‘10-AUG-2018’, 2.00); COMMIT WORK; e. BEGIN WORK; UPDATE CUSTOMER SET CUS_BALANCE = CUS_BALANCE + 100 WHERE CUS_NUM='10936'; INSERT INTO INVOICE(INV_NUM, CUS_NUM, INV_DATE, INV_TOTAL) VALUES ('986391', '10936', ‘15-FEB-2018’, 100); INSERT INTO INVLINE(INV_NUM, PROD_CODE, LINE_PRICE) VALUES ('986391', '1023', 100); UPDATE PRODUCT SET PROD_QOH = PROD_QOH - 1 WHERE PROD_CODE = '1023'; COMMIT WORK; At Site A: f. SELECT CUS_NUM, CUS_NAME, INV_TOTAL FROM CUSTOMER, INVOICE WHERE CUSTOMER.CUS_NUM = INVOICE.CUS_NUM; g. SELECT * FROM INVOICE WHERE INV_TOTAL > 1000; h. SELECT * FROM PRODUCT WHERE PROD_QOH < 10; At Site B: i. SELECT CUS_NAME, INV_TOTAL FROM CUSTOMER, INVOICE WHERE INV_TOTAL > 1000 AND CUSTOMER.CUS_NUM = INVOICE.CUS_NUM; j. SELECT * FROM PRODUCT WHERE PROD_QOH < 10;
1. Specify the number of operations the
2. State what site(s) will be accessed in performing the query.
3. State what types of operations are included in performing the query. For the type:
i. Use the following types listed in (a) – (d) below:
a. Remote request
b. Distributed request.
c. Remote transaction
d. Distributed transaction
ii. Use the table below as a guide also:
Use the following summary:
Number of Distribution Points
Operation Type 1 > 1
Request Remote Distributed
Transaction Remote Distributed
TABLES FRAGMENTS LOCATION
CUSTOMER N/A A
PRODUCT PROD_A A
PROD_B B
INVOICE N/A B
INV_LINE N/A B
Queries to be analyzed at the sites named:
At Site C:
a. SELECT *
FROM CUSTOMER;
b. SELECT *
FROM INVOICE
WHERE INV_TOTAL < 1000;
c. SELECT *
FROM PRODUCT
WHERE PROD_QOH < 10;
d. BEGIN WORK;
INSERT CUSTOMER(CUS_NUM, CUS_NAME, CUS_ADDRESS, CUS_BAL)
VALUES ('34210','Victor Ephanor', '123 Main St', 0.00);
INSERT INTO INVOICE(INV_NUM, CUS_NUM, INV_DATE, INV_TOTAL)
VALUES ('986434', '34210', ‘10-AUG-2018’, 2.00);
COMMIT WORK;
e. BEGIN WORK;
UPDATE CUSTOMER
SET CUS_BALANCE = CUS_BALANCE + 100
WHERE CUS_NUM='10936';
INSERT INTO INVOICE(INV_NUM, CUS_NUM, INV_DATE, INV_TOTAL)
VALUES ('986391', '10936', ‘15-FEB-2018’, 100);
INSERT INTO INVLINE(INV_NUM, PROD_CODE, LINE_PRICE)
VALUES ('986391', '1023', 100);
UPDATE PRODUCT
SET PROD_QOH = PROD_QOH - 1
WHERE PROD_CODE = '1023';
COMMIT WORK;
At Site A:
f. SELECT CUS_NUM, CUS_NAME, INV_TOTAL
FROM CUSTOMER, INVOICE
WHERE CUSTOMER.CUS_NUM = INVOICE.CUS_NUM;
g. SELECT *
FROM INVOICE
WHERE INV_TOTAL > 1000;
h. SELECT *
FROM PRODUCT
WHERE PROD_QOH < 10;
At Site B:
i. SELECT CUS_NAME, INV_TOTAL
FROM CUSTOMER, INVOICE
WHERE INV_TOTAL > 1000 AND CUSTOMER.CUS_NUM = INVOICE.CUS_NUM;
j. SELECT *
FROM PRODUCT
WHERE PROD_QOH < 10;
![TABLES
CUSTOMER
PRODUCT
INVOICE
INV_LINE
FRAGMENTS
N/A
PROD_A
PROD_B
N/A
N/A
CUSTOMER
PROD A
LOCATION
AABBB
B
INVOICE NV_LINE PROD_B
Site C](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6c273e2c-ad0e-4cfe-8772-1a6150bb453f%2F1c43fa0b-b6a6-4e65-bb49-d9bf38488e2d%2Fddtsq48_processed.jpeg&w=3840&q=75)
![Use the following summary:
Operation Type
Request
Transaction
Number of Distribution Points
1
Remote
Remote
>1
Distributed
Distributed](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6c273e2c-ad0e-4cfe-8772-1a6150bb453f%2F1c43fa0b-b6a6-4e65-bb49-d9bf38488e2d%2F7fc2tgl_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)