Question

Give at least 5 indicators which help to identify systems andtables as potential de-normalizationcandidates.

Answer 1

Answer and Explanation:

The five indicators are

• There is existence of repeating groups which needs to be processed in a single group not individually
• many reports exist which need to be processed online
• tables need to processed in different way by different users at the same time
• certain columns need very large time for the de normalization take 60% as the alarming number
• many calculations needs to be applied to columns before queries can be answered