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 the terms i) DDL ii) DML DDL: Data base schema is particular by a set of definitions expressed by a special language known as a data definition language. DML: A data

Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas

List the string operations supported by SQL? 1) Pattern matching Operation 2) Concatenation 3) Extracting character strings 4) Converting among uppercase and lower cas

Is it mandatory to declare all the tables in Report by the key word tables for all the tables that exist in the structure of LDB, and are being explained in the Database part of LD

Describe Query evaluation engine? Query Evaluation engine: Vehicle executes low-level instructions obtained through the DML compiler. The Storage Manager Components gives in

In the ER diagram, one example of subclassing is depicted following the Services entity. The subclasses Item Based and Time Based are created. The entity Services gains the attribu

using the invoice table shown below,write the relational schema,draw a dependencies,inclunding all partial and transitive dependencies.assume that the table does not contain repeat


1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

What are the failures of Controlling Events Between Objects  Failure Unintentional termination of system. Several possible causes: failure of system hardware, o