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

Computer Science SQL Query

Extracted text: Department deptnum deptname offers fax employs phone lo cation hod Student AcademicStaff studentid staffid firstname Course firstname la stname E lastnam e E inancialoan E address coursecode enrolls manages duration - qualifications E coursetitle E phoneextension deptnum officenumber sex dob staffid E address coursecode E position E sex E salary deptn um has consists of undertak es NextOfKin Paper 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.