Denormalized and normalized data
Denormalized data combines redundant data into one table while normalized data stores related data in separate tables. Each type has its pros and cons when analyzing data. However, for data modeling, normalized data is ideal. We will go into the process of converting denormalized data into normalized data in the next section.
The following table lists the important differences between normalization and denormalization: