(A) On January 3, 2018, customer 35 cancelled order invoice 255, which had 2 BB8V01 units on it at $700 ($350 each).

(B) On January 4, 2018, customer 36 makes a 30-day credit purchase of 2 BB-8 droids (product ID BB8V01) at $325 each. The invoice, which only has the one line, was numbered 256.

(C) On January 5, 2018, customer 25 made a payment to their account using $250 cash. This was given payment number 2187.

(D) On January 5, 2018, customer 25 purchased 3 R2 droid (R2DX99) using 60-day credit. These droids have a price of $300 each. The invoice, numbered 2460 only contained the one line.

(E) Assuming that pessimistic locking, but not two-phase locking protocol, is used, create a chronological list of the locking, unlocking, and data manipulation activities that would occur during the processing of part C.

(F) Assuming that pessimistic locking, but not two-phase locking protocol, is used, create a chronological list of the locking, unlocking, and data manipulation activities that would occur during the processing of part D.

(G) Assuming that pessimistic locking with the two-phase locking protocol, is used, create a chronological list of the locking, unlocking, and data manipulation activities that would occur during the processing of part C.

(H) Assuming that pessimistic locking with the two-phase locking protocol, is used, create a chronological list of the locking, unlocking, and data manipulation activities that would occur during the processing of part D.

Paragraph Styles Invoice InvoiceLine PK InviD has is on an PK,FK1 InviD *PK,FK2 DID CID Date QTY Customer #PK CID Name Phone CreditLimit Balance makes LastPaidDate LastPurchDate Total has Price PayTerms Status Total o Droids + PK DID Description QOH Payments PK PMTID I Price Vendor PK VID Name Contact supplies Date FK VID FK CID Amount Phone Address Type Details Paragraph Styles Invoice InvoiceLine PK InviD has is on an PK,FK1 InviD *PK,FK2 DID CID Date QTY Customer #PK CID Name Phone CreditLimit Balance makes LastPaidDate LastPurchDate Total has Price PayTerms Status Total o Droids + PK DID Description QOH Payments PK PMTID I Price Vendor PK VID Name Contact supplies Date FK VID FK CID Amount Phone Address Type Details