Find the functional dependencies, Find the candidate keys of a relation, How to find the candidate keys, Which is the key for the given table, concept of candidate key in dbms, candidate key examples, How many candidate keys are there for a table, Normalize the table to 3nf, Third Normal Form example
- StudentID → StudentName, StudentAddress, TutorId, TutorName
- ModuleID → ModuleName
- TutorID → TutorName
- StudentID alone identifies StudentID StudentName, StudentAddress, TutorID, TutorName attributes. This is one partial dependency.
- ModuleID identifies ModuleID, ModuleName attributes uniquely. This is another partial dependency.