Identifying transitive dependencies

Hi there,

I'm having some trouble identifying transitive dependencies in the student table below

StudId    Name      CourseCode CourseDesc      Lecturer    Grade Office


'S1234', 'Jack',   'C224',     'Database',     'Codd',     'D',  381

'S1234', 'Jack',   'C225',     'Algorithms',   'Djikstra', 'P',  380

'S2345', 'Jill',   'C224',     'Database',     'Codd',     'HD', 381

'S2345', 'Jill',   'C226',     'Architecture', 'Ritchie',  'HD', 390

'S4567', 'Jack',   'C226',     'Architecture', 'Ritchie',  'D',  390

'S4567', 'Jack',   'C224',     'Database',     'Codd',     'F',  381

'S9872', 'Howard', 'Cpol',     'Politics',     'Marx',     'F',  380

I've first tried to find the functional dependencies (they may or may not be correct)

• StudId -> Name
• (StudId, CourseCode) -> Name, CourseDesc, Lecturer, Grade, Office
• CourseCode -> CourseDesc, Lecturer, Office
• CourseDesc -> CourseCode, Lecturer, Office
• Lecturer -> CourseCode, CourseDesc, Office

I then thought that (StudId, CourseCode) -> Office, CourseDesc, Lecturer might be a transitive dependency within student. Is it? Received on Sun Oct 05 2003 - 00:23:22 CDT