i. Definition of Data Warehouse:
A data warehouse is a large, central repository of integrated data collected from various sources. It is designed for query and analysis rather than transaction processing.

ii. Features of a Data Warehouse:

1. Subject-Oriented: Organized around key subjects like customers, sales, and products.
2. Time-Variant: Stores historical data, enabling analysis over time.
3. Non-Volatile: Data is stable and not frequently updated, ensuring consistency for long-term analysis.
4. Integrated: Combines data from multiple sources into a unified format.