Database

A database is nothing but a collection of interrelated data that is organized (rows, columns, and tables) so that it can be easily accessed, managed and updated. A database is sometimes controlled by a management system. The database is classified into two types:

 1. RDBMS (Relational Database Management System)

 In Relational database, the data is stored in relations (tables) in the form of tuples (rows) and attributes (columns) for instance MySql

 2. Non-Relational database(NoSql)

Data Warehouse

A data warehouse is a central store-house containing historical data collected from various sources. This data is used for purely analytical and analysis purposes and aids in making a better decision for an organization. A data warehouse is designed for analysis rather than transaction processing like databases.data warehouses normally use a denormalized data structure.

Data Normalization

Data-normalization means reorganizing data that it doesn't contain redundant data, and all related data items are stored together, with related data separated into multiple tables. The database is normalized data. it supports the quick transaction. The data warehouse is completely normalized data.