Normalisation

Just like a library arranges books by genre, author, and title to help you find what you need quickly, normalization organizes your data to enhance efficiency and accuracy. 📚

Normalization in databases is a process used to organize data, reducing redundancy and improving data integrity.

- Reducing Redundancy 🗃️
- Improving Integrity 🔒
- Enhancing Query Speed 🚀
- Enabling Scalability 📈
- Simplifying Data Cleaning 🧹

𝐓𝐲𝐩𝐞𝐬 𝐨𝐟 𝐍𝐨𝐫𝐦𝐚𝐥 𝐅𝐨𝐫𝐦𝐬:

1𝐍𝐅 (𝐅𝐢𝐫𝐬𝐭 𝐍𝐨𝐫𝐦𝐚𝐥 𝐅𝐨𝐫𝐦)  - Ensures all data is atomic, with no repeating groups. 

2𝐍𝐅 (𝐒𝐞𝐜𝐨𝐧𝐝 𝐍𝐨𝐫𝐦𝐚𝐥 𝐅𝐨𝐫𝐦) - Removes partial dependencies; all non-key attributes depend on the entire primary key. 

3𝐍𝐅 (𝐓𝐡𝐢𝐫𝐝 𝐍𝐨𝐫𝐦𝐚𝐥 𝐅𝐨𝐫𝐦)  - Eliminates transitive dependencies; non-key attributes depend only on the primary key. 

𝐁𝐂𝐍𝐅 (𝐁𝐨𝐲𝐜𝐞-𝐂𝐨𝐝𝐝 𝐍𝐨𝐫𝐦𝐚𝐥 𝐅𝐨𝐫𝐦)  - A stricter version of 3NF, ensuring every determinant is a candidate key. 

4𝐍𝐅 (𝐅𝐨𝐮𝐫𝐭𝐡 𝐍𝐨𝐫𝐦𝐚𝐥 𝐅𝐨𝐫𝐦)  - Eliminates multi-valued dependencies, ensuring no attribute determines multiple independent values.