Determine the primary keys, foreign keys, and composite keys for the given Employee, Emp_Salary, and Department tables after normalization.

Here are the answers to the database task:

1. Determine the following table elements after normalization.

   • Primary keys:

     • Employee table: $\boxed{\text{StaffNo}}$
     • Emp_Salary table: $\boxed{\text{(Staff\_No, Dept\_ID)}}$
     • Department table: $\boxed{\text{Dept\_ID}}$

   • Foreign key:

     • In Employee table: $\boxed{\text{Department}}$ (referencing Dept_ID in Department table)
     • In Emp_Salary table: $\boxed{\text{Staff\_No}}$ (referencing StaffNo in Employee table) and $\boxed{\text{Dept\_ID}}$ (referencing Dept_ID in Department table)

   • Composite keys:

     • $\boxed{\text{(Staff\_No, Dept\_ID)}}$

   • Table containing composite keys:

     • $\boxed{\text{Emp\_Salary}}$

2. Complete the table below.

   	Employees table	Emp_Salary table	Department table
   Number of records	Not provided	Not provided	Not provided
   Number of attributes	6	3	2
   Number of key fields	2	2	1
   Number of fields	6	3	2

   Explanation for "Number of key fields":

   • Employees table: StaffNo (Primary Key) and Department (Foreign Key) are key fields.
   • Emp_Salary table: Staff_No and Dept_ID together form the Composite Primary Key, and both are also Foreign Keys.
   • Department table: Dept_ID is the Primary Key.