(a) (b) Consider two transactions are using a joint account, j. The first transaction attempts to...

 

Transcribed Image Text:

(a) (b) Consider two transactions are using a joint account, j. The first transaction attempts to transfer money to bl and the second transaction attempts to transfer money to b2. Discuss whether the following event can happen. Lost update Deadlock Use an appropriate example/scenario including the interleaving steps if an event can arise or provide a reason if it is not possible for an event to happen. (8 marks) Identify a role for a database for a banking application. Suggest ONE (1) permission that should be granted and one permission that should not be granted for the role you identified. (2 marks) (a) (b) Consider two transactions are using a joint account, j. The first transaction attempts to transfer money to bl and the second transaction attempts to transfer money to b2. Discuss whether the following event can happen. Lost update Deadlock Use an appropriate example/scenario including the interleaving steps if an event can arise or provide a reason if it is not possible for an event to happen. (8 marks) Identify a role for a database for a banking application. Suggest ONE (1) permission that should be granted and one permission that should not be granted for the role you identified. (2 marks)