Diff Agency interview question

General database design question, one coding question to test your logical reasoning.