Asked by Alanna Cooperman on Jun 03, 2024

verifed

Verified

_____ is a set of Access rules that governs data entry and helps ensure data accuracy.

A) A one-to-many relationship
B) A common field
C) Referential integrity
D) Data redundancy

Referential Integrity

A concept in database management that ensures relationships between tables remain consistent, where keys in one table match keys in another.

Data Redundancy

The unnecessary repetition of data within a database, which can lead to inconsistencies and increased storage requirements.

Access Rules

Set of guidelines or permissions defined in a database or application to control access to data or features based on user roles or credentials.

  • Understand the concepts of referential integrity and its importance in data accuracy and relations.
verifed

Verified Answer

ZK
Zybrea KnightJun 08, 2024
Final Answer :
C
Explanation :
Referential integrity is a set of rules in Access that ensures that relationships between tables are valid and that data in related tables is accurate. It helps prevent data entry errors and inconsistencies in the database. A one-to-many relationship refers to the type of relationship between tables in which one record in the first table can relate to many records in the second table, but each record in the second table can only relate to one record in the first table. A common field is a field that appears in multiple tables and is used to create relationships between the tables. Data redundancy refers to the duplication of data in a database, which can lead to errors and inconsistencies. While each of these concepts is important in database design, referential integrity specifically relates to data entry and accuracy rules.