Find the Functional Dependencies for the following Relational Schema:

The Relational Schema is as follows:

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

Primary key: deptName

Foreign key: mgrStaffNo references Staff(staffNo)

 

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

deptName)

Primary key: staffNo

Foreign key: deptName references Department(deptName)

 

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

Primary key: cCode

Foreign key: leaderStaffNo references Staff(staffNo)

Foreign key: deptName reference Department(deptName)

 

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

Primary key: mCode

Foreign key: courseCode references Course(cCode)

Foreign key: cordStaffNo references Staff(staffNo)

 

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

Primary key: matricNo

Foreign key: courseCode references Course(cCode)

 

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

Primary key: matricNo, name

Foreign key: matricNo references Student(matricNo)

 

Undertake(stdMatricNo, moduleCode, performance)

Primary key: stdMatricNo, moduleCode

Foreign key: stdMatricNo references Student(matricNo)

Foreign key: moduleCode references Module(mCode)

 

Teaches(teachStaffNo, moduleCode, hours)

Primary key: teachStaffNo, moduleCode

Foreign key: teachStaffNo references Staff(staffNo)

Foreign key: moduleCode references Module(mCode)

 

Texts(moduleCode, text)

Primary key: moduleCode, text

Foreign key: moduleCode references Module(mCode)

 

Qualifications(qualStaffNo, qualification)

Primary key: qualStaffNo, qualification

Foreign Key: qualStaffNo references Staff(staffNo)