answersLogoWhite

0

The term integrity means to correctness and completeness of the data in data base. A relational data base is collection of related table. Table contains various information. Tables are connected by the foreign key relationship. When the contains with the certain command, insert, delete, update.The integrity of the data can be loss in many different waves.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is integrity problem in dbms?

Integrity problems in a database management system (DBMS) refer to issues such as data inconsistencies, duplicates, or inaccurate information that may arise due to violations of data integrity constraints. These constraints ensure the accuracy and validity of data stored in the database by enforcing rules such as unique values, referential integrity, and domain constraints. Failure to maintain data integrity can lead to errors, data corruption, and compromised reliability of the information stored in the database.


What is a Multi-user DBMS Architecture?

A Multi-user DBMS Architecture is one big system of users and queries. The use of these are to over look and execute plans safely and does not violate and integrity constraints.


Consistency constraints in dbms?

it describes the instance of one entity is associated with each instances of an entity depending upon the range of cardinality constraints are two types they are minimum cardinality maximum cardinality


What ensures the value of the foreign key matches another tables primary key?

It is the DBMS that ensures the value of the foreign key matches another table's primary key when referential integrity constraints are enabled within the DBMS


What do you mean by referral integrity constraints?

What do you mean by referral integrity constraints


Various integrity rules in a DBMS?

Three basic types of database integrity constraints are:Entity integrity, not allowing multiple rows to have the same identity within a table.Domain integrity, restricting data to predefined data types, e.g.: dates.Referential integrity, requiring the existence of a related row in another table, e.g. a customer for a given customer ID.


What does an DBMS do?

DBMS is database management system and it stores data that are related. DBMS maintains data security and integrity as well.


How does SQL allow implementation of the entity integrity and referencial integrity constraints what about general integrity constraints?

sql allow their implementation using various sql commands


What are roles and structural constraints in DBMS?

so it role is basically to manage the database


Is there any difference between integrity and correctness of data in DBMS?

Integrity refers to the structure of the data and how it matches the schema of the database. Correctness could refer to either the integrity of the data or its accuracy (for example, a phone number being incorrect).


Which units of a dbms responsible for structure integrity of a database?

table


Define the two principle integrity rules for the relational modelDisscuss why it is desirable to enforce these rules also explain how DBMS enforces these integrity rules?

Define the two principle integrity rules for the relational modelDisscuss why it is desirable to enforce these rules also explain how DBMS enforces these integrity rules?