Question

In MS Access, if you have two related tables and you check the box to enforce referential integrity, how does the software behave during the insertion of a new record into the many table?

Question 34 options:

1)	It prevents a row from being inserted into the many table if the data in the foreign key column does not match any of the values in the primary key column of the one table.

2)	It prevents any records from being deleted from the primary or secondary table.

3)	It creates a new primary key attribute that is automatically numbered as a sequence of numeric values.

4)	It prevents foreign key values from being duplicated in the many table.

Answer 1

1) It prevents a row from being inserted into the many table if the data in the foreign key column does not match any of the values in the primary key column of the one table.

The purpose of enforcing referential integrity is to prevent orphan records.

Here two tables will have a Parent-Child relationship.

Parent table consist of primary key column and Child table consist of foreign key column.

A primary key with no reference is possible. That is a parent with no child.

A foreign key must match a primary key. A child with no parent violates the rules of referential integrity.

Thus inserting a foreign key that does not match any of the values in the primary key column is not alllowed.