Give a suggested answer for the following interview question for a software engineer:
a. How does RDBMS ensure the properties of Atomicity, Consistency, and Isolation? Explain in terms of specific things they implemented.
b. Give 3 example SQL query that invoke those 3 properties above respectively.
c. What are some common pitfall relating to the 3 properties above in practise? How do you analyze and solve them?