Add 2 employees into EMPLOYEE12 table with one employee should belong to dept_id 1 and another employee should belong to dept_id 2. Remember to create and use Sequence number for employee_id which will start from 1000 and increment by 1 20.Write SQL statement to delete dept_id 1 from Department table. Explain what happens when you attempt the SQL statement 21.To enable delete of department with dept_id 1, you need to use the ON DELETE clause in Foreign Key constraint. Refer to Oracle documentation for further guidance. Drop
Foreign Key constraint and recreate with ON DELETE clause 22.Now, delete department with dept_id 1. Explain what happens
23.Modify table DEPARTMENT12 to add a column DIVISION that should be constrained to check values in the range of 51 and 100
24.Modify DEPARTMENT12 table to add constraint on dept_name to ensure that all records inserted will have dept_name in UPPERCASE. Review Oracle Documentation if needed 25.Test the constraint 26.Write a query to display all constraints for table EMPLOYEE12 and DEPARTMENT12