ION Group Interview Question

Questions on subquery and normalisation. ACID properties