Question 2 (25 marks) Transaction Processing a) MICE is beginning to grow and has taken on more cinemas. The CEO, John Smith, would like to know how the current MICE relational database deals with concurrent, multi-user access. Explain the following terms to him and provide example schedules showing their effects i. Dirty Read [3 marks 1 ii. Unrepeatable Read [3 marks ] Lost Update (Write) [3 marks ] iv. Phantom Read [3 marks ] b) Strict two-phase locking overcomes the issues described above. i. Explain the two types of locks available. [3 marks ] ii. Demonstrate how strict two-phase locking overcomes the problem outlined in section a) for a. Dirty Read b. Unrepeatable Read C. Lost Update Use the same schedules in your answer. [ 6 marks ] c) Explain the term deadlock with a further example schedule. [ 4 marks 1