Pregunta de entrevista de PDG Consulting

Basic SQL table design followed by a system design question