Data Integrity

Posted in Information Technology & Systems, Total Reads: 372
Advertisements

Definition: Data Integrity

It refers to the completeness, consistency and accuracy of the data stored in database or data warehouse. It means that whatever updates and changes is made on the data is validated on various constraints and error checking methods. These integrity constraints are described as below:

Entity integrity: Every table must have one primary key (or a composite primary key) which should be unique and not null. In table employee emp_id is primary key and in table department dept_id is primary key which are not null.

Referential integrity: There may be foreign key in certain tables which can either be primary key of some other table or can be null.  In table department the primary key dept_id is the foreign key of table employee.

Domain Integrity: This states that all columns in the database can contain a defined domain of values. In both the tables all the fields are bound to certain constraints and can contain data which is validated by those constraints only.

Table: Employee

EMp_id

Emp_Name

Salary

Dept_Id

39404

Ashish

50000

20

22876

Sonam

 

20

31399

Anu

60000

30

14069

Anushka

 

40

 

Table: Department

Dept_id

Dept_name

Location

20

Product

Delhi

30

Finance

Noida

40

HR

Gurgaon

 

Advertisements



Looking for Similar Definitions & Concepts, Search Business Concepts