Question: what is data redundancy and inconsistency?
Answer: Data redundancy occurs when the same piece of data exists in multiple places, whereas data inconsistency is when the same data exists in different formats in multiple tables.