This week, you will answer questions based on the following information, table,
ID: 3762591 • Letter: T
Question
This week, you will answer questions based on the following information, table, and SQL syntax. The assignment is based on the contents covered in module 6. You should submit your answers as a Microsoft Word document to the instructor using the “Assignment In-Box”. Please be sure your name is in the file and name your file: yourlastname_yourfirstinitial_chapter#.docx.
Specify the minimum type(s) of operation(s) the database must support (remote request, remote transaction, distributed transaction, or distributed request) in order to perform the following operations:
At site C:
a. SELECT * FROM PRODUCT;
b. SELECT * FROM INVOICE WHERE INV_TOTAL < 2000;
c. SELECT * FROM PRODUCT WHERE PROD_QOH < 25;
d. BEGIN WORK;
UPDATE CUSTOMER
SET CUS_BALANCE = CUS_BALANCE + 200
WHERE CUS_NUM='12934';
INSERT INTO INVOICE(INV_NUM, CUS_NUM, INV_DATE, INV_TOTAL)
VALUES ('867541', '14678', ‘15-DEC-2013’, 200);
INSERT INTO INVLINE(INV_NUM, PROD_CODE, LINE_PRICE)
VALUES ('867541', '1265', 200);
UPDATE PRODUCT
SET PROD_QOH = PROD_QOH - 3
WHERE PROD_CODE = '1265';
COMMIT WORK;
e. BEGIN WORK;
INSERT CUSTOMER(CUS_NUM, CUS_NAME, CUS_ADDRESS, CUS_BAL)
VALUES ('24352','John Brow', '1500 Main St', 0.00);
INSERT INTO INVOICE(INV_NUM, CUS_NUM, INV_DATE, INV_TOTAL)
VALUES ('986434', '24352', ‘22-AUG-2013’, 2.00);
COMMIT WORK;
At Location A:
f. SELECT CUS_NUM, CUS_NAME, INV_TOTAL
FROM CUSTOMER, INVOICE
WHERE INVOICE.CUS_NUM = CUSTOMER.CUS_NUM;
g. SELECT * FROM INVOICE
WHERE INV_TOTAL < 3000;
h. SELECT * FROM PRODUCT
WHERE PROD_QOH > 20;
At Location B:
i. SELECT * FROM CUSTOMER;
j. SELECT CUS_NAME, INV_TOTAL
FROM CUSTOMER, INVOICE
WHERE INV_TOTAL < 2000 AND CUSTOMER.CUS_NUM = INVOICE.CUS_NUM;
k. SELECT *
FROM PRODUCT
WHERE PROD_QOH > 25;
To answer the following questions, remember that the key to each answer is in the number of different data processors that are accessed by each request/transaction. First, identify how many different DP sites are to be accessed by the transaction/request. Next, remember that a distributed request is necessary if a single SQL statement is to access more than one DP site.
Use the following summary:
Explanation / Answer
complete answer is in following ms word document
download link
https://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&uact=8&ved=0CCoQFjACahUKEwjiy8yisZHJAhUHG44KHbAzAlw&url=http%3A%2F%2Fuserhome.brooklyn.cuny.edu%2Firudowsky%2FCISC3810%2Fhw%2FCh12Exercises.doc&usg=AFQjCNHBM_luNKSOXtdKJQ5zpcqFWmxkow&sig2=t0zTnYHNSyd4UbboNOzK7w
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.