CS348-Assign4_

CS348-Assign4_ - a) lost update b) dirty read 3: Is there...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Purdue University Computer Science Department CS 348: Information Systems (Fall 2011) Prof: Bharat Bhargava Due, Nov. 17, 2011 Homework # 4 1. Consider the relation scheme CTHRSG, where C = course, T = teacher, H = hour, R = room, S = student, and G = grade. The functional dependencies F are: C T HR C HT R CS G HS R Find all keys for CTHRSG. 2: Give examples of transaction executions that lead to
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: a) lost update b) dirty read 3: Is there any sense in running a a) 'read only' transaction? b) 'write only' transaction? 4: Give an example of serial schedule, serializable schedule and non-serializable schedule. 5: What is two-phase locking? 6: What can cause a cascade rollback in concurrent transactions?...
View Full Document

Ask a homework question - tutors are online