Consider the following employee and department tables. EMPLOYEE(empno, ename, designation, manager, hiredate, salary, commission, deptno) DEPARTMENT(deptno, dname, location)

i. Create the above tables by properly specifying the primary keys and foreign keys and enter at least five tuples for each relation.

ii. List the employees of employee table in descending order of their salaries.

iii. List the details of highest paid employee in 'SALES' department.