Create a table called DepartmentLocation. Then add the following data to it:

locationId locationName

$1$ CAN

$2$ USA

$2.(2$ Marks$)$ Add a column to the Department table called locationId with type Number.

Modify the locationId of department $3$ to be $2.$ Set every other department$$s

locationId to $1.$

$3.(3$ Marks$)$ Use the Relationships Tool to create relationships between the Department and

Employee tables. Be sure to enforce referential integrity.

a$.$ An employee works in a department

b$.$ An employee supervises an employee

c$.$ A department operates in a location

$4.(3$ Marks$)(1$ each$)$ Modify your Employee table so that:

a$.$ Employees have a Salary field. This field must be greater than or equal to zero.

b$.$ Employees has SIN numbers. These numbers are text and should be a sequence of $9$

numbers. They should display as $000-000-000,$ where the zeros are the SIN number.

c$.$ Add a validation rule that enforces that an employee cannot be their own

supervisor.