If you have any queries please leave a message here
Your Message

Data integrity refers to the accuracy, consistency, and reliability of data that is stored in the database.
There are four types of data integrity :

  1. Row integrity
  2. Column integrity
  3. Referential integrity
  4. User-defined integrity

Row Integrity - Row integrity refers to the requirement that all rows in a table must have a unique identifier that can be used to tell apart each record. This unique identifier is normally known as Primary Key of the table. A Primary Key can be formed by a single column or a combination of multiple columns.

Column integrity - Column integrity refers to the requirement that data stored in a column must adhere to the same format and definition. This includes data type, data length, default value of data, range of possible values, whether duplicate values are allowed, or whether null values are allowed.

Referential integrity - Referential integrity refers to the relationship between tables. Because each table in a database must have a primary key, this primary key can appear in other tables because of its relationship to data within those tables. When a primary key from one table appears in another table, it is called a foreign key. Thus, any primary key field changes must be applied to all foreign keys, or not at all.

User-defined integrity - User-defined integrity refers to a set by a user, which do not belong to the entity, domain, and referential integrity categories.

ABOUT US is an educational website that helps worldwide students in solving computer education related queries.

Also, different software like Visual Studio, SQL Server, Oracle etc. are available to download in different versions.

Moreover, provides solutions to your questions and assignments also.


Windows Command

UNIX Command

IGNOU Assignment Solution

IGNOU Question Paper Solution


Website Devlopment


Home Learning

Provide BCA, MCA Projects

Provide Assignment & Question Paper Solution


Follow Us