题目
题目
单项选择题

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

选项
A.primary key
B.alternate key
C.foreign key
D.secondary key
查看解析

查看解析

标准答案
Please login to view
思路分析
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

登录即可查看完整答案

我们收录了全球超50000道考试原题与详细解析,现在登录,立即获得答案。

类似问题

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

Question at position 15 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? alternate key primary key secondary key foreign key

A foreign key in a relational schema is based on ________ in ERD?

....  is the primary key of another entity to which an entity has a relationship.

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！