Designing with Historical Aggregation in Mind

• If we do not consider future uses of how the aggregate data will be used we run the risk of Introducing Modification Anomalies

Both People and Products will continuously change in the database, how we handle the change can either create or avoid Anomalies