Data redundancy, Database Management System

Data Redundancy-A lot of information is being repeated in the relation. For instance, the information that MCS-014 is named SSAD is repetitive, address of Rahul is "D- 27, Main road, Ranchi" is being repetitive in the first 3 records. Please search the other duplicate information. So we search that the course name, student name,  address, instructor name and office number are being repeated often, thus, the table has Data Redundancy.

Please also note that each time we wish to insert a student record for a subject taken by him/her, say for instance, MCS-013, we have to insert the name of the course as well as the name and office number of its instructor. Also, every time we insert a new course we have to repeat the name and address of the student who has taken it. This replication of information results in troubles in addition to the wastage of space. Notice these problems in the STUDENT relation. What are these problems? Let us explain them.

 

Posted Date: 3/7/2013 1:41:49 AM | Location : United States







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

Write discussion on Data redundancy
Your posts are moderated
Related Questions
Design a gennalization and specialization hierarchy for an automobile sales company

Explain pipelining.        Ans: In order to describe pipelining in simple terms, think of it as breaking down processor functions into smaller and smaller parts. For instance,


SELECT Statement This statement is used for retrieving information from the databases. It can be coupled with many clauses. Let us talk about these clauses in more detail:

Ask question #Minim 100 words accepted#what is recovery management component in database management system and how it is useful

What are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are

You have a friend that runs a motor bike club that holds racing events at various venues on weekends, on a monthly basis. Some venues are private race tracks and some are dirt trac

Unrepeatable reads : Assume T7 reads X twice during its implementation. If it did not update X itself it could be very disturbing to see a dissimilar value of X in its next read. B

Question: In relation to distributed database answer the following questions: (i) Give a brief definition of distributed database. Support your answer with an appropriate di

Economics: It is now usually accepted that it costs less to make a system of smaller computers with the equivalent power of a one large computer. It is more cost-effective to get s