
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, Loose-Leaf Version
- using r languagearrow_forwardWhat significant justification is there for the -> operator in C and C++?arrow_forwardMultidimensional arrays can be stored in row major order, as in C++, or in column major order, as in Fortran. Develop the access functions for both of these arrangements for three-dimensional arrays.arrow_forward
- What are the arguments for and against Java’s implicit heap storage recovery, when compared with the explicit heap storage recovery required in C++? Consider real-time systems.arrow_forward8. Name and Email AddressesWrite a program that keeps names and email addresses in a dictionary as key-value pairs. The program should display a menu that lets the user look up a person’s email address, add a new name and email address, change an existing email address, and delete an existing name and email address. The program should pickle the dictionary and save it to a file when the user exits the program. Each time the program starts, it should retrieve the dictionary from the file and unpickle it. How would the user be able to use the program?arrow_forwardPlease solve and answer the question correctly please. Thank you!!arrow_forward
- Please solve and answer the question correctly please. Thank you!!arrow_forwardW AutoSave Off File Home Insert Draw Design Assignment_1[1] - Protected... ■ Saved V > Search Layout References Mailings Review View Help QuillBot RefWorks - RCM PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing PR Comments Viewing Share × 2. The following state transition table is a simplified model of process management, with the labels representing transitions between states of READY, RUN, BLOCKED, and NONRESIDENT. READY RUN BLOCKED NONRESIDENT READY RUN - 1 - 5 BLOCKED 2 4 3 - 6 Give an example of an event that can cause each of the above transitions. Draw a diagram if that helps. (5) Page 2 of 4 20 of 278 words Text Predictions: On 64 f W Focus + 170% ENG US 17:13 2025/03/24arrow_forwardI need help understanding how could I got the IP Address for the Last Host on this Subnet & the Broadcast Address for this Subnetarrow_forward
- I need help understanding how could I got the IP Address for the Last Host on this Subnet & the Broadcast Address for this Subnetarrow_forwardPlease answer Java OOP homework scenario below: You have been hired by the National Insurance Company to create a program to track insurance policies for all its customers. National Insurance provides three types of insurance: automobile, home and life insurance. The program should be able to track up to 100 policies. Based on the provided information, create an efficient, object-oriented solution with good design principles that will allow a user to manage policies. To do this, the solution should have a menu with the following capabilities: Add Policy o This capability will allow a user to add a policy. The user should specify if the policy is for home, auto, or life. Once the type of policy has been selected, the user should be prompted for all required fields for the policy type. Remove Policy o This capability will allow a user to select any policy and remove it from the list. View policies o This capability will allow a user to see all the policies. All policy fields…arrow_forwardWhat are the two errors in my pseudocode?Module getAverage(Integer value1, Integer value2, Integer value3) Declare Integer average average = value1 + value2 + value3 / 3 Display average End Modulearrow_forward
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningEnhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage Learning
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning




