Create a table called EMP with the following structure

Name

EMPNO

ENAME

JOB

MGR

DEPTNO

SAL

Type

NUMBER$(6)$ NOT NULL

VARCHAR$2(20)$

VARCHAR$2(10)$

NUMBER$(4)$

NUMBER$(3)$

$\frac{?}{NU}$ MBER$(7,2)$

Emp No as the primary key

Create DEPT table with the following structure

NAME

DEPTNO

DNAME

LOC

TYPE

NUMBER$(2)$

VARCHAR$2(10)$

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

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