TABLE $2$: DEPARTMENT

A$.$ Create the table $$DEPARTMENT$$ for the WPC database using the column characteristics as provided in figure $3.$ Use the $$CREATE TABLE DEPARTMENT$$ statement for this.

B$.$ Next insert data in the DEPARTMENT table following figure $4($use INSERT INTO STATEMENTS$).$

Figure $3$: Column Characteristics of Department Table

Figure $4$: Department Data

C$.$ Finally create a relationship between the Department column in the EMPLOYEE table and the DepartmentName column in the DEPARTMENT table and $$enforce referential integrity$.($HINT: Use ALTER TABLE as in chapter $3$ powerpoint slide number $15).$

D$.$ Save the script as $$WPC$-$EmployeeDepartment$\_$lastname.sql$$ and submit the file in D$2$L$.$