SQL SERVER

What is normalization in Sql Server

normalization in Sql Server
Written by shohal

Normalization is the process of organizing data to minimize data redundant(āĻ…āύāĻžāĻŦāĻļā§āϝāĻ•(data duplication)) in a database.

Problem of Redundant

1. Disk Space Wastage  

2. Data Inconsistency  

3. DML Query Can Become Slow

Database normalization Process:

 Database normalization is a step by step process. There are 6 normal forms, First Normal form (1NF) thru Sixth Normal Form (6NF). Most databases are in third normal form (3NF).

About the author

shohal

I have profession and personal attachment with custom ERP Software development, Business Analysis, Project Management and Implementation almost (36) ,also Oracle Apex is my all-time favorite platform to developed the software. Moreover i have some website development experience with WordPress. For hand on networking experience DevOps and CCNA, it create me a full package. Here are some core programming language with networking course i have been worked: Oracle SQL ,PL/SQL,Oracle 19c Database , Oracle Apex 20.1,WordPress,Asp.Net ,MS SQL ,CCNA ,Dev Ops, SAP SD

Leave a Comment