In a database server, how can concurrency control errors be prevented when running two or more transactions together? What approach could be used to error prevention could be used? You should support your answer with a discussion of the fundamental properties of transactions, examples of the main concurrency control problems that occur when two or more transactions are processed concurrently, and how these problems are solved when using your approach to concurrency control error prevention.