Specify the minimum types of operations the database must support to perform the following operations. These operations include remote requests, remote transactions, distributed transactions, and distributed requests. 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 SET WHERE INSERT CUSTOMER INSERT UPDATE WHERE CUS BAL - CUS BAL + 100 CUS_NUM = 10936; INTO INVOICE( INV_ NUM, CUS_ NUM, INV_DATE, INV _TOTAL) VALES (986391, 10936, 15-FEB-2018; 100); INTO LIN E(INV_ NUM, PROD_ NUM, LINE_ PRICE) VALES(986391, 1023, 100); PRODUCT PROD_QOH - PROD_ 00H -1 PROD_NUM = '1023*; e. BEGIN WORK; INSERT INSERT INTO CUSTOMER(CUS NUM, CUS NAME, CUS_ ADDRESS, CUS_BAL) VALES (34210; Victor Ephanor* 123 MainSt' 000); INTO INVOICE(INV_NUM, CUS_ NUM, INV_ DATE, INV _TOTAL) VALES (986434, 134210, 10-AUG-20181 200);
Specify the minimum types of operations the
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
SET
WHERE
INSERT
CUSTOMER
INSERT
UPDATE
WHERE
CUS BAL - CUS BAL + 100
CUS_NUM = 10936;
INTO INVOICE( INV_ NUM, CUS_ NUM, INV_DATE, INV _TOTAL)
VALES (986391, 10936, 15-FEB-2018; 100);
INTO LIN E(INV_ NUM, PROD_ NUM, LINE_ PRICE)
VALES(986391, 1023, 100);
PRODUCT
PROD_QOH - PROD_ 00H -1
PROD_NUM = '1023*;
e. BEGIN WORK;
INSERT
INSERT
INTO CUSTOMER(CUS NUM, CUS NAME, CUS_ ADDRESS, CUS_BAL)
VALES (34210; Victor Ephanor* 123 MainSt' 000);
INTO INVOICE(INV_NUM, CUS_ NUM, INV_ DATE, INV _TOTAL)
VALES (986434, 134210, 10-AUG-20181 200);
Trending now
This is a popular solution!
Step by step
Solved in 3 steps