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
need a DBMS system on any data for assignment.

System Design: An Object Oriented Approach Any software systems always try to change and evolve as technology and business rules evolve. The development of information systems

In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

Define union compatibility? Explain why INTERSECTION of two relations cannot be performed if they are not union compatible? Two relations R(A1, A2,-------, An) and S(B1, B2,--

Explain Hierarchical Model ? Hierarchical Model - It was established to model several kinds of hierarchical organizations which exist in the real world. It uses tree structur

Gaps in sequence values can happen when: -     A rollback happens that is when a statement changes are not accepted. -     When the system crashes -     When a sequence i

Explain the systems development life cycle. This is the traditional method to develop, maintain, and replace information systems that contains the project identification and se

Modular growth: In distributed environments, it is simple to expand. Latest sites can be added to the network without affecting the operations of other sites, as they are somewhat

There are many simple and complex approaches to implement. These reports are based on some views or certain query. The following number of reports can be built. 1. The averag

Question: Consider the following database relations for a textbook ordering system used by a college bookshop: Book (b-copy#, bname, ISBN#, author, price, subject) Order (s#