Center for Academic Computing:

And, the Dept_code field relates to the Employee_code field (primary key). However, the Dept_name field does not directly relate to the Employee_code field (primary key). It is dependent on the Dept_code field. The table contains Employee_code, First_name, Last_name, Region and Dept_code fields. All of these directly relate to the Employee_code ... ................
................