-- TRANSACTION 1
INSERT INTO DWMA08.AUTHOR
VALUES('123456789', 'FUDD', 'ELMER', '5043333333', 'FIRST STREET',
'BAKER', 'CO', 'USA', '70714', '1943-04-25',
0, CURRENT TIMESTAMP, CURRENT TIMESTAMP);
INSERT INTO DWMA08.AUTHOR
VALUES('987654321', 'PIG', 'PORKEY', '3037777777', 'SOME STREET',
'DENVER', 'CO', 'USA', '80013', '1932-06-12',
0, CURRENT TIMESTAMP, CURRENT TIMESTAMP);
COMMIT; -- TRANSACTION 2
INSERT INTO DWMA08.AUTHOR
VALUES('564738291', 'BUNNY', 'BUGS', '3035551212', 'OTHER STREET',
'PARIS', 'FR', 'FRN', '8293879283', '1932-07-04',
0, CURRENT TIMESTAMP, CURRENT TIMESTAMP);
COMMIT;
-- TRANSACTION 3
INSERT INTO DWMA08.AUTHOR
VALUES('192837465', 'DUCK', 'DAFFY', '3031215555', 'SOME STREET',
'LONDON', 'UK', 'UKN', '3473476545', '1932-12-03',
0, CURRENT TIMESTAMP, CURRENT TIMESTAMP);
UPDATE DWMA08.AUTHOR
SET STATE = 'LA',
NUM_UPDATES = NUM_UPDATES + 1,
LAST_UPDATE = CURRENT TIMESTAMP
WHERE AU_SSN = '123456789';
UPDATE DWMA08.AUTHOR
SET COUNTRY = 'USA',
NUM_UPDATES = NUM_UPDATES + 1,
LAST_UPDATE = CURRENT TIMESTAMP
WHERE AU_SSN = '564738291';
COMMIT;
-- TRANSACTION 4
UPDATE DWMA08.AUTHOR
SET COUNTRY = 'FRN',
NUM_UPDATES = NUM_UPDATES + 1,
LAST_UPDATE = CURRENT TIMESTAMP
WHERE AU_SSN = '192837465';
COMMIT;
-- TRANSACTION 5
UPDATE DWMA08.AUTHOR
SET COUNTRY = 'FRN',
NUM_UPDATES = NUM_UPDATES + 1,
LAST_UPDATE = CURRENT TIMESTAMP
WHERE AU_SSN = '987654321';
DELETE
FROM DWMA08.AUTHOR
WHERE AU_SSN IN ('123456789', '564738291');
COMMIT;
