Home › BBA › Information Systems › Database Management › An order table points at the customer table, and…
An order table points at the customer table, and the reference must match a real customer. The pointing field is a:
AForeign key
BStored view
CSort index
DBackup file
Answer & Solution
Correct answer: A. Foreign key
1. It maintains a relationship between tables.
2. It must match a primary key elsewhere.
3. It is a foreign key.
_Source: OpenStax Foundations of Information Systems, Chapter 3, Database Management Systems._
Related questions
In a table of employees, entering the employee ID gives you the name and address. That relA cloud provider copies data to several geographic locations so a hardware failure cannot Routine database work includes performance tuning, security enforcement and, above all, reSensitive records must be protected both while stored and while moving across the network.A manager asks what data integrity actually means. It refers to the accuracy and:A record still points at another record that has been deleted. That dangling record is calTransactions protect consistency and integrity through four properties: atomicity, consistAnother store keeps huge volumes of raw data in their original format until somebody needs