ION Group interview question

Questions on subquery and normalisation. ACID properties