Normal Form in MySQL

Hello everyone, previous article we learned Normalization and its advantages and disadvantages. In this article, we will learn Boyce Codd Normal Form. Let?s go.

MongoDB with .Net Core course link => MongoDB

There are six normal forms available in MySQL.

1st Normal Form (1NF)

2nd Normal Form (2NF)

3rd Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

4th Normal Form (4NF)

5th Normal Form (5NF)

C# basic course click on: C Sharp course

Web API 2- .Net Core In depth In 5 Hours click on:

1. 1st Normal Form (1NF)

In First Normal Form (1NF) should have only single-valued attributes or each table cell should contain a single value. Each column needs to be unique records in first normal form.

For example: following fruits table 1 there is no First Normal Form (1NF) because of a multi-valued attribute in the fruits_names column.

Fruits Table 1:

No fruits_colours fruits_names
1 Red Strawberries, Cherries, Apple
2 Yellow Mango, Orange
3 Green Kiwi

Fruits Table 2: following fruits table 2 there is first normal form because each cell has single values.

No fruits_colours fruits_names
1 Red Strawberries
1 Red Cherries
1 Red Apple
2 Yellow Mango
2 Yellow Orange
3 Green Kiwi

MongoDB with .Net Core course link =>

2.2nd Normal Form (2NF)

A Second Normal Form (2NF) it should be in the First Normal Form (1NF) and relation must not contain any partial dependency.

Fruit Information Table 1:

FINo fruits_colours fruits_names
1 Red Strawberries
2 Red Cherries
3 Yellow Mango
4 Green Kiwi

Fruit Color Category Table 2:

FINo fruits_colours
1 Red
2 Yellow
3 Green

Fruit Name Table 3:

FNNo fruits_names
1 Strawberries
2 Cherries
3 Mango
4 Kiwi

Fruit Table 4:

1 1 1
2 1 2
3 2 3
4 3 4

MongoDB with .Net Core course link =>

3. 3rd Normal Form (3NF)

A Third Normal Form (3NF) it should be in the Second Normal Form (2NF) and it has no Transitive Dependency.

4. Boyce-Codd Normal Form (BCNF)

Third Normal Form (3NF) higher version is Boyce-Codd Normal Form (BCNF) and relation R must be in Third Normal Form (3NF). Boyce-Codd Normal Form (BCNF) for each functional dependency (x à y) x should be a super key. Boyce-Codd Normal Form (BCNF) is free from redundancy and if a relation is in Boyce-Codd Normal Form (BCNF), then Third Normal Form (3NF) is .

C# basic course click on: 

Web API 2- .Net Core In depth In 5 Hours click on:

5. 4th Normal Form (4NF)

A Fourth Normal Form (4NF) it should be in the Boyce-Codd Normal Form (BCNF) and Fourth Normal Form (4NF) tables don?t have Multi-Valued Dependencies on a Primary Key.

6. 5th Normal Form (5NF)

A relation R is in Fifth Normal Form (5NF) if it is in Fourth Normal Form (4NF) and not contains any join dependency. Fifth Normal Form (5NF) can?t be further non-loss decomposed (join dependency).

So this is all about Normalizations six Normal Forms.  

MongoDB with .Net Core course link =>

sagar jaybhay

8 thoughts on “Normal Form in MySQL

  1. I’m really enjoying the design and layout of your site. It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme? Fantastic work!

  2. An impressive share, I simply given this onto a colleague who was doing just a little evaluation on this. And he in truth purchased me breakfast as a result of I found it for him.. smile. So let me reword that: Thnx for the deal with! But yeah Thnkx for spending the time to debate this, I feel strongly about it and love studying more on this topic. If potential, as you become experience, would you thoughts updating your blog with more details? It is extremely useful for me. Huge thumb up for this blog submit!

  3. Hello there, You have done an excellent job. I?l definitely digg it and individually recommend to my friends. I am sure they will be benefited from this web site.

  4. My wife and i got joyous that Emmanuel managed to conclude his basic research with the precious recommendations he came across using your site. It’s not at all simplistic just to be giving for free tactics which usually other folks have been selling. And we also grasp we need the blog owner to appreciate for this. All of the explanations you’ve made, the easy site menu, the relationships your site aid to promote – it’s all superb, and it’s letting our son in addition to the family imagine that this subject is amusing, and that’s tremendously pressing. Many thanks for the whole lot!

  5. I’m not sure where you are getting your info, but
    good topic. I needs to spend some time learning much more or
    understanding more. Thanks for fantastic information I
    was looking for this info for my mission.

  6. Hello There. I found your blog the usage of msn. This is an extremely neatly written article.
    I will be sure to bookmark it and come back to read
    extra of your useful info. Thank you for the post.
    I will certainly comeback.

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top