b$)$ Consider the following relation schema with referential integrity constraints:

$10$

STUDENT $($rollNo$,$ name, degree, year, sex, deptNo, advisor$)$

DEPARTMENT $($depfld$,$ name, hod, phone$)$

PROFESSOR $($empId$,$ name, sex, startYear, deptNo, phone$)$

Page $3$ of $5$

$02000$CST$204052104$

Write SQL DDL statements for the following:

i$.$ Create table STUDENT, DEPARTMENT, PROFESSOR including primary and foreign key integrity constraints.

ii$.$ Add an address attribute in the table STUDENT

iii. Write an SQL statement to delete the $"$CS$"$ department. Given the referential integrity constraints, explain what happens when this statement is executed.