SQL SERVER

What is normalization in Sql Server

normalization in Sql Server
Avatar of shohal
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

Avatar of shohal

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