
Definition of redundancy and problems that can occur due to redundancy.

Explanation of Solution
Redundancy refers to repeated occurrence of same data values at multiple places. For example, consider the student table below:
StudentID | StudentName | Age | Address | Subjects | Marks |
---|---|---|---|---|---|
101 | John Arry | 27 | Park Street | Physics | 80 |
101 | John Arry | 27 | Park Street | Chemistry | 70 |
101 | John Arry | 27 | Park Street | Mathematics | 100 |
104 | Paul Smith | 28 | Avenue Street | Chemistry | 85 |
104 | Paul Smith | 28 | Avenue Street | Physics | 90 |
106 | Massie Williams | 26 | Mathematics | 56 |
The above table consists of redundant data for columns StudentName, StudentID, Age and Address.
This redundancy can result in many problems. Redundancy can result in inconsistencies in data and result in misleading information which can later affect the decision making.
Also, due to redundancy, it becomes very hard to make correction or updation in data. For example, considering the above table, suppose in case the student name for studentID 101 was misread and entered incorrectly. Now, in order to update the correct name it will be time consuming and a cumbersome process since correction needs to be performed at multiple places.
Redundancy also results in eating up extra storage spaces and causes storage files to become heavy. Due to which it becomes time consuming to transfer files or retrieve information from it. Thus, it results in an inefficient system performance.
Want to see more full solutions like this?
Chapter 1 Solutions
EBK CONCEPTS OF DATABASE MANAGEMENT
- 8.7 An ideal germanium pn junction diode has the following parameters: Na = 4 × 10¹5 cm³, Na = 2 × 10¹7 cm³, D₂ = 48 cm²/s, D₁ = 90 cm²/s, Tpo = T = 2 × 10-6 s, and A = 104 cm². Determine the diode current for (a) a forward-bias voltage of 0.25 V and (b) a reverse-biased voltage of 0.25 V.arrow_forward7.20 (a) The peak electric field in a reverse-biased silicon pn junction is |E|= 3 × 105 V/cm. The doping concentrations are N = 4 × 10¹5 cm³ and N. = 4 × 107 cm³. Find the magnitude of the reverse-biased voltage. (b) Repeat part (a) for N₁ = 4 × 10 16 cm³ and N₁ = 4 × 10¹7 cm³. (c) Repeat part (a) for Nd = N₁ = 4 × 10¹7 cm³.arrow_forward7.16 An abrupt silicon pn junction at 7-300 K has impurity doping concentrations of N₁ = 5 x 10 cm³ and N = 10 cm³. Calculate (a) Vbi, (b) W at (i) VR = 0 and (ii) VR = 5 V, and (c) [Emax | at (i) VR = 0 and (ii) VR = 5.arrow_forward
- Can you help me solve it through matlabarrow_forwardI need help with this problem and an explanation of the solution for the image described below. (Introduction to Signals and Systems)arrow_forwardI need help with this problem and an explanation of the solution for the image described below. (Introduction to Signals and Systems)arrow_forward
- DO NOT USE AI, THEY WILL MESS UParrow_forwardDesign an ER diagram for a Hospital Management System. Include weak and strong entity sets, attributes, and relationships.arrow_forwardI need help with this problem and an explanation of the solution for the image described below. (Introduction to Signals and Systems)arrow_forward
- Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSONComputer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier ScienceNetwork+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning
- Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage LearningPrelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson EducationSc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY





