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
Define deadlock avoidance. An alternative method for avoiding deadlocks is to needs additional information about how resources are to be requested. Each request requires the s

Briefly describe the different kinds of users of a DBMS.  Ans: Different sorts of DBMS users are: (a)  Software Engineers: These are the people accountable for developing ap

Question 1 What do you mean by database management system? Question 2 Write a note on Object-Oriented Model Question 3 Explain Sequential File Organization Question

give some example real life situation where DBMS are most suitable

What is Functional Dependency? A Functional dependency is shown by X Y among two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple

Explain nested relations? Nested relations The assumption of INF is a natural one in the bank examples we have considered. However, not all applications are best modelled

examples of fields in a database

Example:  //REVOKE ALL ON EMP FROM MCA12;                              (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-

In which relational modes, cardinality is termed? Answer : Cardinality is termed in a number of tuples relational modes.

Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai