What is a transaction? Describe how lost update and dirty read problems occur in concurrent execution of transactions? Illustrate with examples.

A transaction is a logical unit of work that consists of a sequence of database operations (such as read and write) that must be executed as a single, indivisible unit. A transaction either completes fully (commits) or has no effect at all (rolls back). A transaction must satisfy the ACID propert...