Pregunta de entrevista de Produce Pro Software

Relational database design question given some constraints