Question: Management has requested that you build an employee database. You need to include each employee's current position and salary, as well as all prior positions and salaries with the company. You decide to use a one-to-many structure: an employee table with the main information such as name and address, and an employment table with position and salary history. You can use the employeeID field to connect them. What is employment.employeeID an example of?
- primary key;
- secondary key;
- foreign key;
- alternate key;
Answer: The correct answer of the above question is Option C:foreign key;