What is a foreign key?  Single choice

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.

Log in for full answers

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

Similar Questions

什么是外键？

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

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!