What is a foreign key?  单项选择题

A

A field (or group of fields) that uniquely identifies a given entity in a table.

B

A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables.

C

Characteristics or properties of an entity.

D

A field (or group of fields) that uniquely identifies a given attribute in a table.

登录即可查看完整答案

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

类似问题

什么是外键？

An e-commerce company maintains separate tables for customers and orders within its relational database. Each customer is assigned a unique customer ID in the customer table. When a new order is created, the system records the customer ID alongside order details such as date, product, and quantity. This allows the company to track which customer placed each order and generate reports linking customers to their purchases. In this context, what is the role of the “customer ID” in the Orders table?

In a Database a column or columns used to uniquely identify a row from another table is known as

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

更多留学生实用工具

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