Concurrency control is a process of administering simultaneous operations on the database Without disturbing each other. The technique is performed to prevent interference When two or more users access the database simultaneously. There are three Potential examples of problems caused by conference: I. lost update problem. The update that was successfully completed will be replaced by another user. ii. Uncommitted dependency problems. Happens when one transaction can see the outcome between other transactions before Done done. iii. Inconsistent analysis problem. Happens when the transaction reads some value but the second transaction Renewed some of them during the first execution

Question A. Illustrate in the form of a picture that describes a transaction that describes one of the issues mentioned (select a problem (I) or (ii) or (iii) (10%) B. Illustration also implementing techniques locking to address the problem explained in answer (a) (10%)