Concept:Data redundancy happens when the same data appears more than once in a database unnecessarily.
Explanation:If Table 2 repeats the data already contained in Table 1, then the same information is stored in multiple places.
This unnecessary duplication of data is called data redundancy.
Redundant data is not stored only in one location; it may appear in several rows or fields of a table.
When a piece of data is changed, all the duplicate copies must also be changed.
This makes the database difficult to update and can lead to inconsistent records.
Therefore, deriving Table 2 from Table 1 by repeating or duplicating its data is a result of data redundancy.
It is not achieved through segmentation, replication, or fragmentation.
Answer:C. Redundancy
