Relational Database Management System

Normalization of Tables in DBMS

When we design various tables in DBMS their are chances of anomalies, as they get complex and complex can create problems for the end user and DBA. So normalization is done to ensure that these anomalies are removed and tables can be well organized and readable to user's . 3nf

Advertisements
Relational Database Management System

Data Warehousing

Collecting records and past history of databases helps in proper analysis of information. When Information becomes knowledgeable, it improves various aspects in an organizational growth like productivity control, cost estimation, design profit and loss charts etc. Therefore, we need to understand and have proper knowledge of data warehousing. Data Warehouse Data Mining