Best Design of a Database
The appropriate design of a database would be one in which the basket transaction is identified as the fact, and the daily aggregation is structured to be a large summary table. The load process should be designed to create the daily aggregation from the current operational system, with hooks in place to generate it automatically from basket data once the basket information becomes available.