Home >> MySql >> What is normalization and types of normalization in MySql

What is normalization and types of normalization in MySql

Normalization is a process of analysis a given relation with the help of key and functional dependency to archive desirable properties.

To decompose a bigger relation into smaller relations so that it can satisfy the desirable property.

Desirable property of a good design-

A)-Less NULL value

B)-Lesser redundancy

C)-Avoid data anomolies(Insert,Delete,Update)

Relational model every column should take automic value.

Higher the normal form better is design.

Different nornal form-

1)-1NF

2)-2NF

3)-3NF

4)-BCNF

5)-4NF

6)-5NF

 

Post Your Comment

Next Questions
What is First Normal Form(1NF)
What is Second Normal Form(2NF)
What is Third Normal Form(3NF)
What is Boyce Codd Normal Form(BCNF)
What is Fourth Normal Form(4NF)
What is Fifth Normal Form(5NF)
What is Index and why use indexing
What is clustered index
What is non clustered index
What is primary key index
What is unique key index
What is normal index
What is full text index
What are advantage and disadvantage of indexing
Create database
Drop database
Select database
Create table
Drop table
Truncate table
Insert query
Select table
Where clause
AND Clause
OR Clause

Copyright ©2022 coderraj.com. All Rights Reserved.