Design a star schema for an e-commerce platform that supports both real-time analytical reporting and historical trend analysis.
