Is it necessary to materialize a view ? This defeats the normalization principal for redundant data. Why do designers ignore this rule !!

There could be valid reasons to do this: performance, or audit requirements to freeze the dataset to have a record how the data looked at some point.