XYZ interview question

Normalization, Aksed queries based on project.