transitive dependency

I am a little confused on the definition of this term. Looking at example:

employee number > name, telephone, hrs_worked, pay_rate

This is a makeshift table, with employee number being primary key and non-key attritbutes to the right.

This might not be the best example, but assume pay rate is dependent on hrs_worked, hence, transitive dependency. But, creating another table with hrs_worked as primary key does not make sense, does it?

Thank you.

Bret A. Murphy     Received on Fri Nov 05 1999 - 13:53:43 CST