Oracle interview question

Design a system based on the given requirements