In other words, data warehouse is a normalized database which is designed for performing analysis and execution of queries.