Data is present everywhere and hence its management becomes very important, but the foremost step is cleaning the database which is done by removing any kind of redundant data. Hence, Normalization plays an important role in database management. Hence, In today’s tutorial we’ll be discussing various normalization techniques in MySQL.
The process of minimizing redundancy from a relation or set of relations is referred to as Normalization. Redundancy in relation may cause insertion, deletion and updation anomalies. So, it helps to minimize the redundancy in relations. Normal forms are used to eliminate or reduce redundancy in database tables.
The most common Normalization techniques are 1NF, 2NF, 3NF and BCNF, where “NF” refers to Normal Form. These techniques have different rules and today we’ll be explaining all of that in the simplest way possible. So, watch the complete video for a Great Learning experience.
Following pointers will be covered in this video:
- 00:00:00 Introduction
- 00:51:00 What is Normalization?
- 00:01:27 Types of Normalization
- 00:02:13 Types of Normalization: 1NF
- 00:04:30 Types of Normalization: 2NF
- 00:06:38 Types of Normalization: 3NF
#mysql #database #programming #developer
