Asked by Rachel Wolecki on Sep 25, 2024
Verified
Normally,Access prohibits the deletion of a record in which the primary key matches a foreign key in another table.
Foreign Key
A field (or collection of fields) in one table, that uniquely identifies a row of another table or the same table, used to establish and enforce a link between the data in the two tables.
Primary Key
A unique identifier for each record in a database table, used to ensure that each entry is distinct.
Access
The means or opportunity to approach or enter a place.
- Understand the principles of referential integrity and how it impacts record deletion and updates in relational databases.
Verified Answer
IO
Isaiah ortiz1 day ago
Final Answer :
True
Explanation :
This is known as referential integrity, and it is a feature of relational databases. It ensures that data remains consistent and prevents orphaned records in linked tables. If a record with a matching primary key in another table is deleted, it could result in a loss of data integrity, so Access enforces this restriction by default.
Learning Objectives
- Understand the principles of referential integrity and how it impacts record deletion and updates in relational databases.
Related questions
A Secondary Key Is a Field in One Table Whose ...
When Specifying Referential Integrity,one Way to Handle Deletions Is to ...
When Specifying Referential Integrity,one Way to Handle the Update of ...
________ Means That for Each Value in the Foreign Key ...
_____ Is a Set of Access Rules That Governs Data ...