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
Determine the OBJECTIVES of  object design After passing through this unit, you should be able to: describe and apply concept of generalisation; understand and appl

1. Explain different addressing modes of 8086 Explanation of all addressing modes 2. Write a sequence of instructions to exchange two register contents using stack

Command Line Interfaces: These are interactive interfaces, character-based that let you use the complete power and functionality of the DBMS query language directly. They permit yo

Prove that a relation which is 4NF must be BCNF.   Ans Let R be in 4NF.  Suppose it is not in BCNF.  Hence, there exists an FD X→Y in R such that x is not a super key. Although

Types Of Indexes One of the words used during the file organisation is the term index. In this part, let us describe this term in more detail. We find the index of keywords

Define object-relational systems? Systems that give object-oriented extensions to relational systems are known as object-relational systems.

What is De-normalization? De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because cur

Inheritance Adjustment As in object oriented analysis and design terms inheritance defines a relationship between classes, where as one class shares structure or behaviour def


i am not clear with the climetic condition of the north indian plain. can u plz explain it for me