CSE 480 Midterm: CSE 480 MSU Exam 2018 version a Exam
46 views9 pages
31 Jan 2019
School
Department
Course
Professor
Document Summary
Answer the questions in the spaces provided on the page. If you run out of room for an answer, continue on the back of that page. 50 points (a) (30 points) which dependencies are obeyed in the relation below? (select all true dependences) Fill in the additional dependent rows as needed (you may not need all available space). name josh zizhen josh josh id. After the statement is completed by the associated connection, write which connections are holding each type of lock in the table. If no connection holds a type of lock, leave it blank. A connection can only hold one lock at a time. If an action can"t be granted the necessary locks, cross out that action and proceed as if that action wasn"t in the schedule (don"t perform a rollback). You are given a relation with 8 attributes {a,b,c,d,e,f,g,h} and the following func- tional dependencies: