Assignment 2: Data Warehouse

This document discusses the improvements made in the conceptual design of a data warehouse, the analytics subject of interest for hospitals, the star schema for the prescription fact, the aggregation schema for analysis, the Oracle DDL statements for creating the database, and the strategy for loading data into the tables.