Oracle Interview Question

Design a system based on the given requirements