Please Oraclae question

Assignment#1 Using your APEX account Upload the script file "Scott" which includes the commands for creating EMP and DEPT tables, then do the following tasks: 1. Add New Column (Email) to Dept Table. (2) 2. Add unique constraint to Email column. (2) 3. Add new Department to Dept table. (you choose an appropriate data and fill all fields) (2) 4. For the employees who take commission increase the salary by the commission value if their salary is less than 1500 by. (2) 5. Remove comm column from emp table. (2)