This is a database management systems course problem.

$1.$ Consider the following SQL code for updating a database:

$$

On May $11,2016,$ customer $10010$ makes a credit purchase $(30$ days$)$ of one unit of product $11$QER$/31$ with a unit price of $$110\mathrm{.}00$; the tax rate is $8$ percent. The invoice number is $10983,$ and this invoice has only one product line.

$$

BEGIN TRANSACTION

INSERT INTO INVOICE

$$ i$.$ VALUES $(10983,10010,11-$May$-2018,118\mathrm{.}80,30,$OPEN$)$;

INSERT INTO LINE

$$ i$.$ VALUES $(10983,1,11$QER$/31,1,110\mathrm{.}00)$;

UPDATE PRODUCT

$$ i$.$ SET P$\_$QTYOH $=$ P$\_$QTYOH $1$

$$ ii$.$ WHERE P$\_$CODE $=11$QER$/31$;

UPDATE CUSTOMER

SET CUS$\_$DATELSTPUR $=11-$May$-2018,$ CUS$\_$BALANCE $=$ CUS$\_$BALANCE $+118\mathrm{.}80$

WHERE CUS$\_$CODE $=10010$;

COMMIT;

$$

The following is the transaction log that is created:

$$

$$

TRL

ID

TRX

NUM

PREV

PTR

NEXT

PTR

$$

OPERATION

$$

TABLE

$$

ROW ID

$$

ATTRIBUTE

BEFORE

VALUE

AFTER

VALUE

$987$

$101$

Null

$1023$

START

$*$ Start Trx$.$

$$

$$

$$

$$

$1023$

$101$

$987$

$1026$

INSERT

INVOICE

$10983$

$$

$$

$10983,10010,$

$11-$May$-2018,118\mathrm{.}80,30,$ OPEN

$1026$

$101$

$1023$

$1029$

INSERT

LINE

$10983,1$

$$

$$

$10983,1,11$QER$/31,1,110\mathrm{.}00$

$1029$

$101$

$1026$

$1031$

UPDATE

PRODUCT

A

P$\_$QTYOH

$47$

$46$

$1031$

$101$

$1029$

$1032$

UPDATE

CUSTOMER

$10010$

CUS$\_$BALANCE

$345\mathrm{.}67$

B

$1032$

$101$

$1031$

$1034$

UPDATE

CUSTOMER

$10010$

C

D

E

$1034$

$101$

$1032$

Null

COMMIT

$*$ End Trx$.*$

$$

$$

$$

$$

$1089$

$102$

Null

$1091$

START

$*$ Start Trx$.$

$$

$$

$$

$$

$$

$$

$$

$$

$$

Fill in the missing values: A$,$ B$.$ C$,$ D$,$ E