Department deptnum deptname offers fax employs phone lo cation hod Student AcademicStaff studentid staffid firstname Course firstname E lastnam e E inancialloan coursecode la stname enrolls manages...

Extracted text: Department deptnum deptname offers fax employs phone lo cation hod Student AcademicStaff studentid staffid firstname Course firstname E lastnam e E inancialloan coursecode la stname enrolls manages duration - qualifications address E coursetitle phoneextension deptn um offi cenumber sex dob staffid E address coursecode E position E sex E salary deptn um has consists of undertakes NextOfKin Раper firstname рарercode Assessm ent A lastnam e papertitle result E relationship E phone startdate score enddate papercode address resources studentid tstudentid coursecode For the above given database schema you are required to develop a SQL query for the creation of the Student, Department and the NextofKin tables also embedded all the constraint in them accordingly.