
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
Concepts of Database Management
- 5. Task 5: Write a function that takes an array and its size as parameters and returns the sum of its elements(Homework)arrow_forward4.13 Extract a 3×3 array from the upper left-hand corner of the magic square you created in 4.11. Is this also a magic square?arrow_forwarda If an M/M/1 queue in a server has task arrivals at a rate of 30 per second and serves at a rate of 50 per second, how many tasks are in the system (waiting and being served) on average? b In part (a), how many tasks are being served, on average? c What is the utilization of an M/M/1 queue in a server that has four tasks waiting on average?arrow_forward
- Evaluate the average gate capacitance of, and power dissipated by, a processor with the following properties: • Gate oxide thickness = 1.4 nm• Gate length = 65 nm• Gate area = (65 nm)x(65 nm)• Permittivity of free space = 8.85 x 10e−12 Farads/m • Relative permittivity of SiO2 = 3.9 • Rail-to-rail voltage = 1.1 V• Clock frequency = 3.6 GHz• Switching probability = 1.0• Number of transistors per die = 1.3 x 10e9arrow_forwardCan you conver the following C code into ARM Assembly. Assume a is X0 and b is X1if ((a !=0) && (b == 0)) {a++} else {b++}arrow_forwardPlease help. Matlab for engineers 6th edition question.arrow_forward
- A certain proram takes 26.67 seconds to run on 3 processors and 16 s to run on 7 processors. Find the execution time on one processor, the fraction of the program that can be parallelized, the theoretical execution time on an infinite number of processors, and P1/2arrow_forwardCan you write the following C code into ARM Assembly. Assume x is X0 and y is X1:switch ( x ) {case 0 : y++; break ;case 1 : y−−; break ;default : break ;}arrow_forwardCan you write the following C code into ARM Assembly? Assume a is in X0 and b is in X1:while ( a < 10){b=b +10;a++;}arrow_forward
- # Instructions a. 1.00E+09 b. 1.00E+09 Compiler A Compiler B Execution time #Instructions Execution time 1s 1.20E+09 1.4 s 0.8 s 1.20E+09 0.7 s 1.6.1 [5] For the same program, two different compilers are used. The table above shows the execution time of the two different compiled programs. Find the average CPI for each program given that the processor has a clock cycle time of 1 nS. 1.6.2 15] Assume the average CPIs found in 1.6.1, but that the compiled programs run on two difference processors. If the execution times on the two processors are the same, how much faster is the clock of the processor running compiler A's coce versus the clock of the processor running compiler B's code? 1.6.3 [5] A new compiler is developed that uses only 600 million instruc- tions and has an average CPI of 1.1. What is the speed-up of using this new compiler versus using Compiler A or B on the original processor of 1.6.1? Consider two different implementations, P1 and P2, of the same instruction set.…arrow_forwardExercise 1.4 Consider two different implementations of the same instruction set architecture. There are four classes of instructions, A, B, C, and D. The clock rate and CPI of each implementation are given in the following table. CPI Class B CPI Class C CPI Class D Clock rate CPI Class A P1 1.5 GHz 1 2 3 P2 2 GHz 2 2 2 4 2 1.4.1 [10] Given a program with 10" instructions divided into classes as follows: 10% class A, 20% class B, 50% class C and 20% class D, which implemen- tation is faster? 1.4.2 [5] What is the global CPI for each implementation? 1.4.3 [5] Find the clock cycles required in both cases. The following table shows the number of instructions for a program. Arith 500 Store 50 Load 100 Branch 50 Total 700 1.4.4 [5] Assuming that arith instructions take I cycle, load and store 5 cycles and branch 2 cycles, what is the execution time of the program in a 2 GHz processor? 1.4.5 [5] Find the CPI for the program. 1.4.6 [10] If the number of load instructions can be reduced…arrow_forwardGiven a PN junction diode with Acceptor doping (Na) to be 1016 per cm3 and Donor Doping (Nd) to be 1015 per cm3. Find Built in voltage Vo at room temperature (300K), then find the depletion width (Wdep) in micrometers.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





