Explain how you would design a database schema to support both historical reporting and real-time analytical queries.
