Identifying transitive dependencies

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 - 07:23:22 CEST