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...
Modify the program you wrote in Exercise 15.16 to read an odd number in the range 1 to 19 to specify the number of rows in the diamond. Your program should then display a diamond of the appropriate size.
What will be an ideal response?
Each column in a database is called a(n):
A) table. B) record. C) field. D) index.
Military intelligence officers may be interested in security certification.
Answer the following statement true (T) or false (F)
The LGA1151 socket and latest Coffee Lake chipset support what type of RAM?
A. DDR3 B. DDR3 (only if low voltage) C. DDR4 D. DDR5