How to ensure that related records in different tables are created or modified consistently and that partially written data does not occur? What is ACID and what are the levels of transaction isolation?