$$ Create a table called EMP with the following structure

Name Type

EMPNO NUMBER$(6)$ NOT NULL

ENAME VARCHAR$2(20)$

JOB VARCHAR$2(10)$

MGR NUMBER$(4)$

DEPTNO NUMBER$(3)$

SAL NUMBER$(7,2)$

Emp No as the primary key

$$ Create DEPT table with the following structure

NAME TYPE

DEPTNO NUMBER$(2)$

DNAME VARCHAR$2(10)$

LOC VARCHAR$2(10)$

Dept No as the Primary Key

Questions to be solved

$$ Add constraints to the EMP table that EMPNO as the PRIMARY KEY and DEPTNO as the FOREIGN KEY.

$$ Inserting $7$ records using a single INSERT ALL commands in both tables

$$ Add constraints to the EMP table to check the EMPNO value while entering $($i$.$e$)$ EMPNO $>100$

$$ Add a column DOB to the EMP table.

$$ Update the EMP table to set the commission of all employees to Rs $1000/-$ who are working as MANAGERS.

$$ Create a MANAGER table from the EMP table which should hold details only about the managers

$$ List the EMPLOYEE NAMES and the DEPARTMENT NAME in which they are working.

$$ Display the rows whose EMPNO ranges from $1002$ to $1005.$

$$ Count the total records in the emp table

$$ Display the employee name and department name in which they are working implementing a right outer join