Question
Asked Jan 25, 2020
104 views

Explain what is meant by the term data redundancy with the help of two tables of data.

check_circle

Expert Answer

star
star
star
star
star
1 Rating
Step 1

Data redundancy:

  • It means repetition of same data in the computer storage memory.
  • It causes wastage of computer’s memory space.
  • It increases the memory processing overheads.
  • Data redundancy in database means some data fields with repetitive data, which cause performance issue.
  • It also causes system integrity and consistency issues.
  • It increases the size of database.
  • For removing duplicate records and maintain the integrity of the database normalization technique is used.
  • Normalization involves cleaning up of unnecessary duplicate data from the database.
Step 2

Explaining redundancy, consider the table given below:

Computer Engineering homework question answer, step 2, image 1
fullscreen
Step 3

In the above given table,

Teacher name and subject fields are repeated and there is no need of this repetition as the teacher can be classified by using teacher ID. So, creating a new table for teacher which contains teacher ID as a primary key (unique key) and stores all the relevant attribute of teacher entity to avoid redundancy in the database.

By using normalization, creating tw...

Computer Engineering homework question answer, step 3, image 1
fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Engineering

Computer Engineering

Database Management

Related Computer Engineering Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: 1.1 Show that the following sets satisfy the law of contradiction and law ofexcluded middle.X = {a, ...

A: The conditions for to satisfy the law of contradiction and the law of excluded middle are:

question_answer

Q: Use the Java Class, Account.java, provided. Please do not rename or make any changes to this class. ...

A: Program DescriptionTwo java files rinoel_Bank.java and rinoel_testBank.java contain the correspondin...

question_answer

Q: Why is it important that the protocols used on the Internet are available for free in their most bas...

A: Click to see the answer

question_answer

Q: public class TestAverage {public static void main(String[] args) {int test1, test2, test3, sum;Scann...

A: The objective of the program is to calculate the average, now since the variable which holds the ave...

question_answer

Q: Hi, how can I find out what kind of thread models (one-one, one-many or many many) does my operating...

A: Thread model used by operating system:Whenever there is a need for the operating system to multiplex...

question_answer

Q: 1. Assume we build a binary max-on-top heap from keys 10, 12, 1, 14, 6, 5, 8, 15, 3, 9, 7, 4, 11, 13...

A: Hello. Since you have posted multiple questions and not specified which question needs to be solved,...

question_answer

Q: Consider the UDP header 12 03 00 OF 00 lE A3 10. What is the total length of the UDP? a) 32 bytes b)...

A: The UDP header contains for parts:Source portDestination portLengthChecksum

question_answer

Q: Use Eclipse for this program

A:  Step 1: Import required package.Step 2: Define “AnalyzeNumbers” class.Step 3: Define main function....

question_answer

Q: John is a great collector of pennies.  He wants to exchange his jar of pennies for as many quarters,...

A: Create a class with the main method in it, and initialize all required variables like currency names...