EDICOM interview question

Solving a simple Database question