LAB#$5$ Activities

$1-$ Create Employees table with the following columns:

Eno, EName $,$ EBirthday, EAge, EEmail, EBranch, EDepartment

ENo is a primary key

EAge is not null and has to be less than or equal to $60$

EEmail should be a unique value

$2-$ Create Department table with the following columns:

Dno, DName, Dlocation

Dno is a primary key

$3-$ Drop EBranch column from Employees table

$4-$ Add a new column called DManager to Department table

$5-$ Add not null constraint to DManager column

$6-$ Add a new constraint as a foreign key on EDepartment column from

Employees table and link it to Department$($Dno$)$ Add ON DELETE SET NULL

$7-$ Drop the unique constraint from EEmail column in Employees table

$8-$ Change a constraint name to a new name

$9-$ Change EBirthday column name from Employees to EBD

$10-$Change Employees table name to EMP

$11-$Insert the following values into Department table:

$\backslash$table$[[$Dno$,$DName,Dlocation,DManager$],[1,$HR$,$SA$,39$