Question: What is a foreign key, and how does it enforce referential integrity?Answer: A foreign key is a field that refers to the primary key in another table. It enforces referential integrity by ensuring that values in the foreign key match values in the referenced table's primary key. |
Save For Revision
Bookmark this item, mark it difficult, or place it in a revision set.
Log in to save bookmarks, difficult questions, and revision sets.
Is it helpful? Yes No
Most helpful rated by users:
- Explain the concept of ACID properties in the context of databases.
- What is the purpose of the WHERE clause in a PostgreSQL query?
- What is a foreign key, and how does it enforce referential integrity?
- Explain the purpose of the SERIAL data type in PostgreSQL.