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: StaffNo Emp\_Salary table: (Staff\_No, Dept\_ID) Department table: Dept\_ID Foreign key: In Employee table: Department (referencing Dept\_ID in Department table) In Emp\_Salary table: Staff\_No (referencing StaffNo in Employee table) and Dept\_ID (referencing Dept\_ID in Department table) Composite keys: (Staff\_No, Dept\_ID) Table containing composite keys: 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. That's 2 down. 3 left today — send the next one.