Data integrity refers to the accuracy, consistency, and reliability of data that is stored in the database.
There are four types of data 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.
IGNOU Assignment Solution
IGNOU Question Paper Solution
Solutions of Different Questions
WHAT WE DO
Provide BCA, MCA Projects
Provide Assignment & Question Paper Solution