Specify The Minimum Types Of Operations The Database Must Support

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 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 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

Posted in Uncategorized