What is the purpose of a foreign key in a relational database?
- Defining table constraints
- Enforcing data uniqueness
- Establishing relationships between tables
- Performing calculations on data
A foreign key in a relational database establishes relationships between tables by linking the primary key of one table to a corresponding column in another table, enforcing referential integrity.
Loading...
Related Quiz
- What is the primary advantage of using a document-oriented NoSQL database?
- What strategies can be employed to optimize index usage in a database?
- How do data modeling tools like ERWin or Visio facilitate collaboration among team members during the database design phase?
- The integration of ________ in monitoring systems enables proactive identification and resolution of issues before they impact data pipeline performance.
- In Dimensional Modeling, a ________ is a central table in a star schema that contains metrics or measurements.