Normalization in MySQL



MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/

Normalization is the procedure of professionally organizing data in a database. Normalization database schema design technique, by which an existing schema is modified to minimize redundancy and dependency of data, eliminating redundancy data means this goal will storing the same data in more than one table and the second one is ensuring data dependencies make sense means only storing related data in a table. In organizing data Normalization split a large table into smaller tables and it defines relationships among them to increases the simplicity.

C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/ 
Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/


There are six normal forms available in MySQL.
1.        1st Normal Form (1NF)
2.        2nd Normal Form (2NF)
3.        3rd Normal Form (3NF)
4.        Boyce-Codd Normal Form (BCNF)
5.        4th Normal Form (4NF)
6.        5th Normal Form (5NF)

C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/ 
Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/
Advantages of Normalization
v  Normalization is theoretically cleaner and cooler to maintain and modification as your need modifications.
v  Searching, creating and sorting indexes are faster when using normalization.
v  Normalization helps in reaching resource optimization with increases in MySQL database design.
v  Normalization database data is always real, it is not ambiguous.
v  Using normalization we normalize the database, as we convert the large table into a smaller table that leads to data.
v  Normalization is better performance and fast queries.
v  Normalization database improved data integrity as it splits all the data into separate entities.

MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/


Disadvantages of Normalization
v  Normalization has more tables to join as by spreading out data into more tables.
v  Normalization design in the database we need experienced database designer (proper knowledge).
v  Normalization design is difficult and expansive. 
v  Normalization is hard to model the database without knowing the customers’ requirements.

C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/ 
Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/

Next article we learn about six normal forms.

MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/

Comments

Post a Comment

Popular posts from this blog

ALTER statement in MySQL

Image
Hello and welcome everyone. In this article, we will learn about the ALTER table statement in MySQL. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ MySQL ALTER command is used to modify the table, view an existing database. When you have completed your database design and after that, you realize some of the information was left out when creating a database. You want to change without losing existing data, and then you can change data using ALTER command. MySQL ALTER command is used to add a column with an existing table, add multiple columns, drop a column, modify a column, rename a column, and rename the table. ALTER command also used to add and drop constraints on the existing table. ...
Read more

MySQL Constraint – PRIMARY KEY

Image
C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ Hello everyone in the previous article we learn about MySQL Constraint – UNIQUE and in this article, we will learn PRIMARY KEY constraint with example. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ What is the PRIMARY KEY? MySQL PRIMARY KEY constraint uniquely identifies each row in a table and also it creates a unique index for accessing the table will access faster. The columns of a Primary Key cannot have null values in MySQL and it must contain unique values. A Primary key has only one on a table, if the primary key used with multiple fields, then they are called a Composite Key. Syntax 1 for creating PRIMARY KEY with CREATE table statement.      ...
Read more

Order By Clause in MySQL

Image
Hello and welcome everyone. In this article, we will learn about the Order By Clause in MySQL. Let’s go. MongoDB with .Net Core course link => https://www.udemy.com/mongodb-with-net-core-sagar-jaybhay/ C# basic course click on: https://www.udemy.com/learn-csharp-with-sagar-jaybhay/  Web API 2- .Net Core In depth In 5 Hours click on: https://www.udemy.com/web-api-2-net-core-in-depth-in-5-hrs-with-sagar-jaybhay/ MySQL Order by clause is used to sort the records or data in ascending or descending order. Order by clause allows us to sort records or data by a single column or multiple columns in ascending or descending order. There are two key using in Order by clause:          ASC: - sorting data or records by ascending order.          DESC: - sorting data or records by descending order. Syntax:          SELECT column_name_1, column_n...
Read more