You are the administrator for a college campus. You suspect the database design created by students in the Computer Science department fails to meet the third normal form. What the criteria failures for this requirement?
Answer – Aggregate values are stores in tables.
(The third normal form criterion bans the storage of aggregated data. Remember, the goal is to store data once. Aggregated (derived or calculated) data can be mathematically produced from other columns. Sometimes these data are stored for performance reasons (reducing the number of joins required in a query) but only after justifying the additional storage expense.)