DATA INTEGRITY

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

QuestionSolves.com 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, QuestionSolves.com provides solutions to your questions and assignments also.


MORE TOPIC


Windows Command

UNIX Command

IGNOU Assignment Solution

IGNOU Question Paper Solution

Solutions of Different Questions


WHAT WE DO


Website Devlopment

Training

Home Learning

Provide BCA, MCA Projects

Provide Assignment & Question Paper Solution


CONTACT US


Follow Us