PDG Consulting interview question

Basic SQL table design followed by a system design question