Relational database integrity, Database Management System

A database is a set of data. But, is the data kept in a database trustworthy? To answer that query we must first answer the question. What is integrity?

Integrity simply means to keep the consistency of data. Therefore, integrity constraints in a database make sure that changes made to the database by authorised users do not compromise data consistency. Therefore, integrity constraints do not permit damage to the database.

There are primarily two integrity constraints: the referential integrity constraint and the entity integrity constraint. In order to describe these two, let us first describe the term Key with respect to a Database Management System.

Posted Date: 3/6/2013 6:29:29 AM | Location : United States







Related Discussions:- Relational database integrity, Assignment Help, Ask Question on Relational database integrity, Get Answer, Expert's Help, Relational database integrity Discussions

Write discussion on Relational database integrity
Your posts are moderated
Related Questions
folding method and mid square method using visual basic

what do you mean by consistency in rdbms?

Project Description: We have purchased facebook style chat software which we are using with our site. It is prepared in PHP but the rest of the site is developed asp.net. Iss

Differance between internal and external schema? Internal and external schema: Internal Schema • Describes the physical storage structure • Uses a physical data model External

What is the full form of ODBC ? ODBC stands for Open Database Connectivity.

Timestamps For Read operations: If TS (T) If TS (T) >= W-timestamp (Q), then the transaction T is trying to read a value of data item Q which has been written and committed

QUESTION (a) Give two advantages of using Linked List as compared to arrays. (b) (i) You are working as programmer at the Orange Mauritius branch. You have been asked to cre


Describe entity referential integrity and integrity. Give an example of each. Entity Integrity Rule - If there is a attribute A of relation R is a prime attribute of R then A

Explain Foreign Key? Foreign Key - Let there are two relations (tables) R and S. Any candidate key of the relation R that is referred within the relation S is known as the fo