Distinguish between the following: Database and Data warehouse.

Database: A database is a collection of related information stored in a structured form, typically in tables, to facilitate easy insertion, deletion, and manipulation of data. Databases consist of tables containing attributes. Most computer applications, including antivirus software, spreadsheets, and word processors, have databases at their core. Data Warehouse: A data warehouse is a database system optimized for reporting and analysis. It generally refers to a combination of many different databases across an entire enterprise. Once data is entered into a data warehouse, it can only be loaded, refreshed, and accessed for queries. It usually contains historical data derived from transaction data but can also include data from other sources. Data warehousing emphasizes capturing data from diverse sources for useful analysis and access, but it does not typically start from the end-user's perspective, who might need access to specialized, sometimes local, databases.