Discuss and illustrate out the three (3) types of possible mistake which could occur if concurrency control isn’t properly enforced in database system. Support your answer with suitable illustration for each.
Illustrate out the data access protocol based upon the compatibility matrix.
Illustrate out the term “deadlock” and provide an illustration.
Illustrate out how deadlock state can be detected and how the system can break such state.