I want the answer to this: On May 11. 2010. customer 10010 makes a credit purcha

Question

I want the answer to this:

On May 11. 2010. customer 10010 makes a credit purchase (30 days) of one unit of product 11QER/31 with a unit price of $110.00; the tax rate is 8 percent. The invoice number is 10983. and this invoice has only one product line. Assuming that pessimistic locking with the two phase locking protocol is being used. create a chronological list of the locking. unlocking, and data ma activities that would occur during the complete processing of the transaction described in Problem 6a.

Explanation / Answer

The list of transactions activities that occur during the transaction

·         Read Table CUSTOMER

·         Read Table PRODUCT

·         Lock Table PRODUCT

·         Write Table PRODUCT
-         Unlock Table Product

·         Read Table INVOICE

·         Read Table LINE

·         Lock Table PAYMENTS
Write Table PAYMENTS

·         Unlock Table PAYMENTS

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.