Database Design Related assignment .. to do with PL/SQL

Database Design Related assignment .. to do with PL/SQL