Data Integrity

Data integrity ensures which the data entered into the database through the user is checked for it’s correctness and is the data which is supposed to go into the database. Therefore, the data gets automatically  validated  when  it  is  entered  as  per  the  instructions  or  commands  of  the designer and through this way RDBMS ensures in which the application has a high degree of data integrity and security.

RDBMS  ensures  data  integrity  via  automatic  validation  of  data  using  integrity constraints. The constraints are non-procedural constructs and through just specifying those and the designer can automate the validation procedure at the time of data entry. Popular integrity constraints are UNIQUE, NOT NULL, FOREIGN KEY PRIMARY KEY, and CHECK constraints.