In the accompanying figure, analyst names appear more than once in the table. Storing this data on multiple records is an example of redundancy which can cause several problems.What are these problems? What is the solution to the problem?
What will be an ideal response?
Redundancy causes the following problems:
1. Wasted storage space. The same name is stored more than once. It should be stored only once.
2. More difficult database updates. If the same name is stored more than once and the individual's name changes, then the name would need to be changed in several different places.
3. A possibility of inconsistent data. There is nothing to prohibit a name being changed on one record and not on another.
The solution to the problem is to place the redundant data in a separate table.
You might also like to view...
A manual line break allows text to be moved to a new line while remaining part of the preceding paragraph
Indicate whether the statement is true or false
The desktop version of ________ has an option to turn its popup blocker off and on
Fill in the blank(s) with correct word