Question

Which of the following is a correct statement about entity integrity rule?

1) The rule is regarding how to use foreign keys.
2) The rule is used to verify the type of data values in each table.
3) The rule requires each record's primary key cannot be blank (null).
4) The rule allows each primary key must be used to link tables.

Answer 1

The entity integrity rule requires each record's primary key cannot be blank (null), helping maintain data consistency and integrity in a database.

Step-by-step explanation:

The correct statement about the entity integrity rule is option 3) The rule requires each record's primary key cannot be blank (null). The entity integrity rule is a fundamental principle in database design that ensures each entity in a relational database has a unique primary key, and that the primary key values are not null. This rule helps maintain data consistency and integrity in the database.