Discuss the ACID properties in database management systems. What do each of the properties (Atomicity, Consistency, Isolation, Durability) entail, and why are they crucial for reliable transaction processing? Provide examples where applicable.
Focus on defining each property clearly and explaining its significance in maintaining data integrity and reliability in relational databases. Include real-world scenarios to illustrate your points.