CSE 480 Midterm: CSE 480 MSU Exam 2018 version a Exam

46 views9 pages

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:

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers

Related Documents

Related Questions