You are tasked with designing a schema for an Amazon Redshift data warehouse that will store transaction data from multiple retail stores. The data includes store IDs, transaction dates, product IDs, quantities sold, and prices. The schema must be optimized for querying large volumes of data and should support future changes in data characteristics. Which of the following schema designs would be most appropriate?