oracle

Q: Login to SQL and write SQL queries to do the following: 1. Create Employee and Department tables based on the following table specification and add all Constraints: Employee Department Size Size Column name *DNO DName Data Type Varchar2 5 2 Varchar2 15 2 15 Column name Data Type *SSN Varchar2 Name Varchar2 **Derinum Varchar2 Age number Primary Key, **Foregone Key Age 18 Name not null DName unique 2 2 I 2. Fill the tables with this data: SSN Name Dept.num Age 111 Sarah 1 25 112 Nourah 2 30 DNO 1 DName Accounting Management 2 3 IT 3. Change the department number to 2 for only sarah, 4. Remove IT department from department table