What are the primary, foreign, and composite keys for the normalized Employee, Emp_Salary, and Department tables?

Here are the table elements after normalization:

• Primary keys:

  • Employee table: StaffNo
  • Emp_Salary table: (Staff_No, Dept_ID) (This is a composite key, as it uniquely identifies a salary record for a specific employee within a specific department.)
  • Department table: Dept_ID

• Foreign keys:

  • Emp_Salary table: Staff_No (references StaffNo in the Employee table)
  • Emp_Salary table: Dept_ID (references Dept_ID in the Department table)

• Composite keys:

  • Emp_Salary