FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Integrity constraints are rules that help to maintain the accuracy and consistency of data in a database. They can be used to enforce business rules or to ensure that data is entered correctly. For example, a simple integrity constraint in DBMS might state that all customers must have a valid email address.

Detailed explanation-2: -Data integrity rules specify the criteria that need to be met to insure that the data resource contains the highest quality necessary to support the current and future business information demand. Precise means clearly expressed, definite, accurate, correct, and conforming to proper form.

Detailed explanation-3: -Integrity Constraints are the protocols that a table’s data columns must follow. These are used to restrict the types of information that can be entered into a table. This means that the data in the database is accurate and reliable. You may apply integrity Constraints at the column or table level.

Detailed explanation-4: -Three types of integrity constraints are an inherent part of the relational data model: entity integrity, referential integrity and domain integrity.