Oracle interview question

question on airline system design