Explain the concept of integrity in DB2 along with types of integrity

Problem: What is INTEGRITY in a DB2? Explain DOMAIN, ENTITY and REFERENTIAL integrity with the help of an example in ORDERS table.

Solution

The integrity refers to the accuracy, consistency and correctness of data present in the DB2 database. Data integrity is imposed during the database design to make sure that data residing in the database remains complete, accurate and reliable.

There are three types of integrity described in below figure.

Domain integrity

It ensures that column data in the DB2 table adhere to the permissible set of values. For example, in the ORDERS table, the domain integrity on the ORDER_DATE column ensures that data in this column is always in DATE format.

Entity integrity

It ensures that each row in a DB2 table is unique. This integrity is achieved using the primary key. For example, the ORDERS DB2 table has a primary key as ORDER_ID, which cannot be duplicated throughout the table.

Referential integrity

It ensures that data integrity is maintained between primary and foreign key. For example, ORDERS DB2 table has a primary key as ORDER_ID and foreign key as TRANSACTION_ID which refers to the TRANSACTIONS DB2 table.

Mandalika

Updated on 01-Dec-2020 04:53:43

• Related Questions & Answers
• What are the types of data integrity?
• Verifying MySQL Package Integrity
• What is Data Integrity?
• Explain the concept of DYNAMIC SQL in DB2 with the help of an example
• Referential Integrity Rule in RDBMS
• Entity Integrity Rule in RDBMS
• Security, Integrity and Authorization in DBMS
• What are integrity constraints over the relation in DBMS?
• Explain the concept of amalgamation
• Explain the concept of DBMS schema with examples?
• Explain the concept of Regular expression.
• Explain the concept of trial balance
• What is the difference between data security and data integrity?
• Explain the concept of foreign keys with examples(DBMS)?
• Explain the concept of depreciation in accounting.