Home > IT 344 SEU Physical Database Design Computer Science Worksheet
IT 344 SEU Physical Database Design Computer Science Worksheet
Learning Outcome(s):
LO2 Apply the concepts of transaction management, concurrency and recovery of a database.
1. What are the important factors that influence physical database design?
2. Consider the three transactions T1, T2, and T3, and the schedules S1 and S2 given below. Transaction T1: r1(x); r1(z); w1(x) Transaction T2: r2(z); r2(y); w2(z); w2(y) Transaction T3: r3(x); r3(y); w3(y) recovery of a database. Schedule S1: r1(x); r2(z); r1(x); r3(x); r3(y); w1(x); w3(y); r2(y); w2(z); w2(y) Schedule S2: r1(x); r2(z); r3(x); r1(z); r2(y); r3(y); w1(x); w2(z); w3(y); w2(y) Draw the serializability (precedence) for S1 and S2 and state whether each schedule is conflict serializable. Write down the equivalent serial schedule(s) if a schedule is serializable.
3. Explain the violations caused by each of the following: a) Dirty Read b) Non-repeatable Read c) Phantoms
4.Apply the In the Schedule below determine the undo and redo and rollback transaction concepts of transaction management, concurrency and recovery of a database. LSN 2 Marks Log 00 UpdateT1 writes P5 05 Update T2 writes P3 10 T2 commit 15 T2 End update 20 Update T3 writes P1 25 Update: T3 writes P3 30 T4 read P5 35 Update: T4 write P5 40 T4 commit 45 T4 End update CRASH Purchase answer to see full attachment
