First Resonance Interview Question

Given some data requirements, construct a SQL table.