1 List an example of Normalized data and an example of Denor

1. List an example of Normalized data and an example of Denormalized data other than the one in our lecture. There is no definitive answer for this. You use your own words to express your understanding about Normalizing and denormalizing data.

Solution

Example for Denormalised Data.

Denormalised data is the data which is combined and grouped into one. I.e. consider above in that we have employee and department data combined into one table. With unnormalised data we always have ambiguities or anomalies because when we only delete the employee data from the above table there is loss in corresponding department data in that row. This will cause issues in data.

Example for Normalised Data.

Employee.

Department:-

Normalised data is the data which is divided and grouped a related information or data . We can say this as a meaningfull data. We can easily understand and manage as well.