$$ 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