Entity Integrity in RDBMS


Entity integrity defines a row as a unique entity for a particular table.We can enforce the Entity Integrity through the indexes, UNIQUE constraints, PRIMARY KEY constraints, or IDENTITY properties.
Example,if we entered the emp_id is 1 in a table,the database should not allow other emp_id with the same value of 1.

No comments:

Post a Comment