Discuss and illustrate the three (3) types of potential mistake which could happen if concurrency control isn’t properly enforced in database system. Support your answer with suitable illustration for each.
Discuss and illustrate the data access protocol based upon the compatibility matrix.
Illustrate out the term “deadlock” and provide an ex.
Discuss how a deadlock state can be detected and how the system can break such state.
Data warehouse can be stated as “a subject-oriented, time-variant, integrated, non-volatile collection of data” in support of management’s decision making procedure. Describe each of the above concepts and support your answer with suitable illustration.