9 What is database normalization | Normalization in DBMS

Опубликовано: 07 Июль 2022
на канале: education tatva

Hi All,

Another video part of database series. In this lecture, i explained what is database normalization and how to use them.

This lecture consist details about

1) First Normal Form
2) Second Normal Form
3) Third Normal Form
4) BCNF: Boyce and Codd Normal Form
5) Fourth Normal Form
6) Fifth Normal Form
7) Sixth Normal Form(Proposed)

Also covered below topics
1) Primary Key in database
2) Foreign Key in database
3) Composite Key in database
4) Difference between Primary Key & Foreign Key

Here is the quick index:

Video
00:00 What is database normalization
00:40 Importance of normalization in dbms
1:21 Different forms of normalization
2:13 Denormalized data
3:34 First Normal Form in Database
3:57 Second Normal Form in Database
5:47 Primary Key and Foreign Key
7:29 What is composite key
8:46 Difference between primary key and unique key
10:11 Third Normal Form in Database

WhiteBoard Link

https://jamboard.google.com/d/1d8bMno...

Github link
https://github.com/educationtatva/dat...

Mic Blue Yeti : https://amzn.to/3foVQi5
Camera : https://amzn.to/3uRM1iW
Laptop : https://amzn.to/3vF6kAQ

Web
https://www.educationtatva.com

Facebook
  / educationtatva

Instagram
  / educationta.  .

Twitter
  / educationtatva

Medium
  / educationtatva

Query
[email protected]

#databasenormalization #SQlNormalForm #dbms