Hello, So I need help with my Transaction HW for my data managment class. I have written a program below and need help pinpointing the "redo/undo" logs. Can some help me? -------------------------------------------------------------------------------------------------------------------------------------------- DROP TABLE FINANCE; CREATE TABLE FINANCE ( ACCOUNT_NUMBER int CONSTRAINT FINANCE_ACCOUNT_NUMBER NOT NULL ,OWNER varChar(10) CONSTRAINT FINANCE_OWNER NOT NULL ,ACCOUNT_TYPE varChar(20) CONSTRAINT FINANCE_ACCOUNT_TYPE NOT NULL ,BALANCE decimal CONSTRAINT FINANCE_BALANCE NOT NULL ,CONSTRAINT FINANCE_pk PRIMARY KEY (ACCOUNT_NUMBER) ); INSERT INTO FINANCE VALUES (1234567, 'Adam', 'Checking', 1945.00); INSERT INTO FINANCE VALUES (2197683, 'George', 'Savings', 2345.00); DROP USER gerstld; CREATE USER gerstld; GRANT SELECT, UPDATE, INSERT, DELETE ON FINANCE TO gerstld; SELECT * FROM FINANCE; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; BEGIN TRAN -- transac SELECT sum(BALANCE) FROM FINANCE; UPDATE FINANCE SET BALANCE = BALANCE - 1000 WHERE ACCOUNT_NUMBER = 2197683; UPDATE FINANCE SET BALANCE = BALANCE + 1000 WHERE ACCOUNT_NUMBER = 1234567; COMMIT TRAN; BEGIN TRAN T1 UPDATE FINANCE SET BALANCE = BALANCE + (BALANCE*0.1) WHERE ACCOUNT_TYPE LIKE 'SAVINGS'; UPDATE FINANCE SET BALANCE = BALANCE + (BALANCE * 0.05) WHERE ACCOUNT_TYPE LIKE 'CHECKING'; COMMIT TRAN T1; SELECT sum(BALANCE) FROM FINANCE;
Hello, So I need help with my Transaction HW for my data managment class. I have written a program below and need help pinpointing the "redo/undo" logs. Can some help me?
--------------------------------------------------------------------------------------------------------------------------------------------
DROP TABLE FINANCE;
CREATE TABLE FINANCE (
ACCOUNT_NUMBER int CONSTRAINT FINANCE_ACCOUNT_NUMBER NOT NULL
,OWNER varChar(10) CONSTRAINT FINANCE_OWNER NOT NULL
,ACCOUNT_TYPE varChar(20) CONSTRAINT FINANCE_ACCOUNT_TYPE NOT NULL
,BALANCE decimal CONSTRAINT FINANCE_BALANCE NOT NULL
,CONSTRAINT FINANCE_pk PRIMARY KEY (ACCOUNT_NUMBER)
);
INSERT INTO FINANCE VALUES (1234567, 'Adam', 'Checking', 1945.00);
INSERT INTO FINANCE VALUES (2197683, 'George', 'Savings', 2345.00);
DROP USER gerstld;
CREATE USER gerstld;
GRANT SELECT, UPDATE, INSERT, DELETE ON FINANCE TO gerstld;
SELECT * FROM FINANCE;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
BEGIN TRAN -- transac
SELECT sum(BALANCE)
FROM FINANCE;
UPDATE FINANCE
SET BALANCE = BALANCE - 1000
WHERE ACCOUNT_NUMBER = 2197683;
UPDATE FINANCE
SET BALANCE = BALANCE + 1000
WHERE ACCOUNT_NUMBER = 1234567;
COMMIT TRAN;
BEGIN TRAN T1
UPDATE FINANCE
SET BALANCE = BALANCE + (BALANCE*0.1)
WHERE ACCOUNT_TYPE LIKE 'SAVINGS';
UPDATE FINANCE
SET BALANCE = BALANCE + (BALANCE * 0.05)
WHERE ACCOUNT_TYPE LIKE 'CHECKING';
COMMIT TRAN T1;
SELECT sum(BALANCE)
FROM FINANCE;
Step by step
Solved in 2 steps
