Total Page Preview: 000000000534
What is Normalization and it basic types in SQL in English and Hindi
Normalization and it basic types in English
Normalization is a technique used to organize data in a database efficiently, by eliminating redundancy and improving data integrity. It involves dividing a database table into smaller, more manageable tables, and defining relationships between them. This helps to reduce data duplication, eliminate data inconsistencies, and ensure data accuracy.
Normalization is important because it helps to reduce data redundancy, which can lead to data inconsistencies, anomalies, and errors. It also helps to improve data integrity, by ensuring that each piece of data is stored only once, and that all related data is stored together in the same table.
-
Normalization is the process of organizing the data in the database.
-
Normalization is used to minimize the redundancy from a relation or set of relations. It is also used to eliminate undesirable characteristics like Insertion, Update, and Deletion Anomalies.
-
Normalization divides the larger table into smaller and links them using relationships.
-
The normal form is used to reduce redundancy from the database table.
There are several types of normalization, but the most commonly used are the first three normal forms:
1-First Normal Form (1NF)
The first normal form requires that each table in the database has a primary key, and that each column in the table contains atomic values (i.e., values that cannot be further subdivided).
2-Second Normal Form (2NF)
The second normal form requires that each non-key column in the table is functionally dependent on the entire primary key, and not on only part of it.
3-Third Normal Form (3NF)
The third normal form requires that each non-key column in the table is dependent only on the primary key, and not on any other non-key columns.
Normalization beyond 3NF includes Boyce-Codd Normal Form (BCNF), Fourth Normal Form (4NF), and Fifth Normal Form (5NF). These are more advanced techniques used to further eliminate redundancy and improve data integrity.
Normalization and it basic types in Hindi
Normalization ek technique hai jo database tables ko organize karne ke liye istemal kiya jata hai, jisse data redundancy ko kam kiya ja sakta hai aur data integrity improve kiya ja sakta hai. Is technique ke istemal se, tables ko chote-chote parts mein divide kiya jata hai aur unhe tab tak modify kiya jata hai jab tak ki unme redundancy aur data inconsistencies na khatm ho jaaye.
Normalization ke kuchh mukhya prakar hote hain, jinhe normal forms kaha jata hai. SQL mein, 1NF, 2NF, 3NF, Boyce-Codd Normal Form (BCNF), 4NF, aur 5NF sabhi prakar ki normal forms hote hain. Inme se kuchh prakar niche diye gaye hain:
1-First Normal Form (1NF)
1NF ko satisfy karne ke liye har table mein ek primary key hona chahiye aur har column atomic honi chahiye. Yani, har column mein ek hi value honi chahiye aur usse aur koi further subdivision nahi kiya ja sakta hai.
2-Second Normal Form (2NF)
2NF ko satisfy karne ke liye har non-key column keval primary key ke sath functionally dependent hona chahiye aur kisi bhi partial dependency ko remove kar diya jana chahiye. Partial dependency ka matlab hota hai ki kuchh non-key columns sirf primary key ke kuchh parts par depend karte hain.
3-Third Normal Form (3NF)
3NF ko satisfy karne ke liye har non-key column kisi bhi aur non-key column par depend nahi hona chahiye, sirf primary key par depend hona chahiye. Agar koi non-key column dusre non-key column par depend karta hai, to usse remove kar dena chahiye.
4-Boyce-Codd Normal Form (BCNF)
BCNF ko satisfy karne ke liye har determinant kisi bhi candidate key ka proper subset nahi hona chahiye. Yani, har determinant candidate key ke sath directly associated hona chahiye.
5-Fourth Normal Form (4NF)
4NF ko satisfy karne ke liye har table mein ek multi-valued dependency nahi honi chahiye. Agar multi-valued dependency hai, to table ko divide kar dena chahiye.
6-Fifth Normal Form (5NF)
5NF ko satisfy karne ke liye har table mein ek join dependency honi chahiye. Yani, har column ka kisi aur column ke sath join hona chahiye, jisse unki correlation pata chal sake.
Normalization ka istemal database ko better organization aur data consistency ke liye kiya jata hai. Har normal form ko satisfy karne ke liye, table ko modify kiya jata hai aur data redundancy ko kam kiya jata hai.
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com