SCHOOL sid (PK) S. Name (PK) Head -Name (PK) Dean Name HEAD Head Name (PK) Job_title e-mail CAMPUS Campus_id (PK) location kname (PK) location DEPARTMENT 7D-ID (PK) | D- Name (PK) HOD Dep of School mail - add SEMESTER sem-Ne sem - Narne COURSE courre_id () course name rept Name PROGRAM Name (PK) Duration I d) Write down SQL statements of the following queries applied on your datasets/ mapping How do you display under which Dean who (faculty) is working. select from emp where emp.job= "HOD and Which depannya super Which department lies under which school? select from where doo = 001; shoof department Which syllabus of course will be approved by Dean under which school