Specify the minimum type(s) of operation(s) the database must support (remote request, remote transaction, distributed transaction, or distributed request) to perform the following operations:

At site C

a. SELECT *

FROM CUSTOMER;

b. SELECT *

FROM INVOICE

WHERE INV_TOT > 1000;

c. SELECT *

FROM PRODUCT

WHERE PROD_ QOH < 10;

d. BEGIN WORK;

UPDATE CUSTOMER

SET CUS_BAL = CUS_BAL + 100

WHERE CUS_NUM = '10936';

INSERT INTO INVOICE(INV_NUM, CUS_NUM, INV_DATE, INV_TOTAL)

VALUES ('986391', '10936', '15-FEB-2010', 100);

INSERT INTO LINE(INV_NUM, PROD_NUM, LINE_PRICE) VALUES('986391', '1023', 100);

UPDATE PRODUCT

SET PROD_QOH = PROD_ QOH -1

WHERE PROD_NUM = '1023'; COMMIT WORK;

e. BEGIN WORK;

INSERT INTO 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-2009', 2.00);

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 *

FROM CUSTOMER;

j. SELECT CUS_NAME, INV_TOTAL

FROM CUSTOMER, INVOICE

WHERE INV_TOTAL > 1000 AND CUSTOMER.CUS_NUM=INVOICE.CUS_NUM;

k. SELECT *

FROM PRODUCT

WHERE PROD_QOH < 10;