List the ACID properties of transactions. Explain why each property is essential for transactions to function correctly. Select a favorite strategy for reusable database components (number table, precalculated table, etc.) and explain a scenario where it would be useful. Finally, compare and contrast optimistic and pessimistic concurrency enforcement.