Lack of redundancy, Database Management System

Lack of Redundancy We have talked about the problems of repetition of information in a database. Such repetition should be stay away as much as possible. Let us state once again that redundancy may lead to inconsistency. Alternatively controlled redundancy sometimes is vital for the recovery in database system.

 

Posted Date: 3/7/2013 2:24:15 AM | Location : United States







Related Discussions:- Lack of redundancy, Assignment Help, Ask Question on Lack of redundancy, Get Answer, Expert's Help, Lack of redundancy Discussions

Write discussion on Lack of redundancy
Your posts are moderated
Related Questions
What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

What is recovery management component? Ensuring durability is the responsibility of a software component of the base system known as the recovery management component.

Class Diagram A class diagram is required to support functional necessity of system. In a static design view, class diagram is used to model vocabulary of the system, simple c

Describe the Composite Key Composite Key: Sometimes one key is not enough to uniquely recognize a row. E.g. in a single class Roll is enough to search a student, but in the w

Parallelism of transaction execution: A transaction can be divided into various sub-queries that can operate on fragments in parallel. This enhances the degree of concurrency in t

Let us now make the E-R diagram for the student database as per the explanation given in the previous section. We can also states the overall logical structure of a database usi


Construct an ER diagram for a hospital along with a set of patients and a set of medical doctors Associate with every patient a log of the several tests and examinations conducted.

tell me the functionality,advantages and disadvantages of student database

Explain Candidate key? Candidate Key - A candidate key is a minimal superkey, that can be used to uniquely identify a tuple in the relation.