A company has two tables in their database: 'Employees' and 'Departments'. Each employee is assigned to one department. To ensure that the 'Employees' table references the correct department data, what kind of special field should be included in the 'Employees' table?
A unique key in the 'Employees' table for each department
A foreign key that references the 'Departments' primary key
An additional primary key in the 'Employees' table for department data
A composite key made from combining employee and department data
A foreign key is used to link the records in one table to the records in another, establishing a relationship between the two tables. In this case, including a foreign key in the 'Employees' table that references the primary key of the 'Departments' table maintains data integrity by ensuring that each employee is associated with an existing department.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a primary key in a database?
Open an interactive chat with Bash
Why is a foreign key important in relational databases?
Open an interactive chat with Bash
What is the difference between a foreign key and a composite key?
Open an interactive chat with Bash
CompTIA ITF+ FC0-U61 (V5)
Database Fundamentals
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .