Domanda di colloquio di Produce Pro Software

Relational database design question given some constraints