Which type of relational integrity is violated if a primary key in a database has a null value?
Which type of relational integrity is violated if a primary key in a database has a null value?
Entity integrity is violated when a primary key attribute in a database table has a null value. Entity integrity ensures that the primary key of a table uniquely identifies each row, and it should not contain any null values. A primary key is used to uniquely identify a record in a table, and having null values in the primary key would result in ambiguity and violation of the uniqueness constraint.
A. Entity integrity Entity integrity is violated when a primary key attribute in a database table has a null value. Entity integrity ensures that the primary key of a table uniquely identifies each row, and it should not contain any null values. A primary key is used to uniquely identify a record in a table, and having null values in the primary key would result in ambiguity and violation of the uniqueness constraint.