One approach to avoiding deadlocks is to require each transaction to announce all the locks it wants at the beginning, and to either grant all those locks or deny them all and make the transaction wait. does this approach avoid deadlocks due to locking? either explain why, or give an example of a deadlock that can arise.