Department deptnum deptname offers fax employs phone lo cation hod Student AcademicStaff studentid staffid firstname Course firstname E lastnam e E finandalloan 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 finandalloan coursecode la stname enrolls manages duration - qualifications E coursetitle deptn um E phoneextension offi cenumber address sex dob staffid E address coursecode E position E sex E salary deptn um has consists of undertakes NextOfKin Paper firstname рарercode Assessm ent A lastnam e papertitle result E relationship H 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.