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
- I 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- | العنوان I need a detailed drawing with explanation so A 4 شكا +x-pu +965 Taylor Series Approximation Example- H.W More terms used implies better approximation f(x)+ f(x) Zero order First order 1.0 0.5 x-0 Second order True f(x) f(x) • flx;+ 1) = f(x) + fƒ '\x;}h √(x,+ 1) = f(x) + f (x)h + "(x) 2 f(x1) X+1-1 f(x) 0.1x 0.15x³-0.5x²-0.25x+1.2 Taylor Series Approximation H.w: Smaller step size implies smaller error Errors 100+ F(x) Zero order First order Second order 0.5 Reduced step size 0 x, 0 f(x+1)f(x,) + ƒ\x,}h 51 f(x + 1) − f(x) + (x)+2 ((x1) +1-1 Using Taylor Series Expansion estimate f(1.35) with x0 =0.75 with 5 iterations (or & s= 5%) for f(x) 0.1x 0.15x³-0.5x2- 0.25x+1.2 マ 52arrow_forward
- Home Work Use Taylor's series expansion to Compute the true and approximate percent relative errors & and εa for x = π/6, use 6 iterations for the series. sin(x) == x-arrow_forwardTaylor Series Approximation Example- H.W More terms used implies better approximation f(x) 4 f(x) Zero order f(x + 1) = f(x;) First order f(x; + 1) = f(x;) + f'(x;)h 1.0 Second order 0.5 True f(x + 1) = f(x) + f'(x)h + ƒ"(x;) h2 2! f(x+1) 0 x; = 0 x+1 = 1 x h f(x)=0.1x4-0.15x³- 0.5x2 -0.25x + 1.2 51 Taylor Series Approximation H.w: Smaller step size implies smaller error Errors f(x) + f(x,) Zero order f(x,+ 1) = f(x) First order 1.0 0.5 Reduced step size Second order True f(x + 1) = f(x) + f'(x)h f(x; + 1) = f(x) + f'(x)h + "(xi) h2 f(x,+1) O x₁ = 0 x+1=1 Using Taylor Series Expansion estimate f(1.35) with x0 =0.75 with 5 iterations (or & s= 5%) for f(x)=0.1x 0.15x³-0.5x²- 0.25x + 1.2 52arrow_forwardFind the error: daily_sales = [0.0, 0,0, 0.0, 0.0, 0.0, 0.0, 0.0] days_of_week = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'] for i in range(7): daily_sales[i] = float(input('Enter the sales for ' \ + days_of_week[i] + ': ')arrow_forward
- I 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_forwardSolve the following questions by WRITING YOUR INSTRUCTION CODE in Assembly language. 1. Modify the Lab 4 Tutorial 1 to allow USERS TO ENTER the following parameter and displaythefinal result. You are also required to store the results in the memory named ‘output’. Findthesum of the last four numbers in the array. For example, assume the value of n is 10, the sumwillbe 10+9+8+7= 34 (in decimal). Your console should display the following:Please enter the value of n: 10The sum of the last four numbers is 34Thank you. Before computing the difference of the numbers in the array, your code must performachecking; if n < 3, you should display a message ‘The value of n is less than 4’, and no operationwill be performed. In this case, your console should display the following: Please enter the value of n: 1 The entered n is less than 3. Thank you Type the…arrow_forward
- I 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_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