Design a data warehouse schema for the medium-sized business application. A full history of changes for every entity (table) is required. Lecture Most data warehouses follow Summary Table architecture...

Design a data warehouse schema for the medium-sized business application. A full history of changes for every entity (table) is required. Lecture Most data warehouses follow Summary Table architecture using history tables to track change history, but you may follow Star Schema architecture using Type 2 dimensions is you wish.
Design a data mart (star) schema for your medium-sized business data warehouse schema. All dimensions must be Type 2, meaning a full history of changes is required. Lecture under the heading "Handling History in Star Schema Data Warehouses.