Normalize the following Schema into 3NF:

Department (deptName, phone, faxNo, location, mgrStaffNo, mgrStartDate)

Primary Key: deptName

Functional Dependencies:

phone, faxNo, location -> deptName

mgrStartDate -> mgrStaffNo

Course (cCode, title, duration, leaderStaffNo, deptName)

Primary Key: cCode

Functional Dependencies:

title, duration, leaderStaffNo, deptName -> cCode

Module (mCode, title, startDate, endDate, coursework, exam, courseCode, drctStaffNo)

Primary Key: mCode

Staff (staffNo, fName, lName, address, phone, officeNo, sex, salary, post, computerID,

deptName)

Primary Key: staffNo

Functional Dependencies:

fName, lName, address, phone, officeNo, sex, salary -> staffNo

Student (matricNo, fName, lName, town, street, postCode, dob, sex, loan, courseCode)

Primary Key: matricNo

Functional Dependencies:

fName, lName, town, street, post Code, dob, sex, loan, courseCode -> matricNo

Next-Of-Kin (matricNo, name, phone, relationship)

Primary Key: matricNo, name

Functional Dependencies:

name, phone, relationship -> matricNo

Undertakes (stdMatricNo, moduleCode, performance)

Primary Key: stdMatricNo, moduleCode

Functional Dependencies:

performance -> stdMatricNo, moduleCode 

Teaches (teachStaffNo, moduleCode, hours)

Primary Key: teachStaffNo, moduleCode

Functional Dependencies:

hours -> teachStaffNo, moduleCode

Texts (moduleCode, text)

Primary Key: moduleCode, text

Qualifications (qualStaffNo, qualification)

Primary Key: qualStaffNo, qualification

These two don't seem to have any functional dependencies: