Questions
Questions
Single choice

Question at position 13 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 alternate key foreign key secondary key

Options
A.primary key
B.alternate key
C.foreign key
D.secondary key
View Explanation

View Explanation

Verified Answer
Please login to view
Step-by-Step Analysis
The scenario describes linking two tables: an employee table containing main information, and an employment table containing position and salary history. The connection between these tables is made using employeeID, which is stored in both tables. This type of field is used to reference records in another table, establishing a relationship between the two tables.......Login to view full explanation

Log in for full answers

We've collected over 50,000 authentic exam questions and detailed explanations from around the globe. Log in now and get instant access to the answers!

Similar Questions

More Practical Tools for Students Powered by AI Study Helper

Join us and instantly unlock extensive past papers & exclusive solutions to get a head start on your studies!