Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Why Normalization is important in DBMS ?

Why its a requirement that a system should be normalized and it will give best results regarding fetching data in form of reports

user-image
Question ajoutée par Shariq ALi Syed , Operations Readiness Coordinator , Fluor Arabia
Date de publication: 2014/07/10
DURGESH YADAV
par DURGESH YADAV , ASSISTANT PROGRAMMER , DISTRICT ELECTION OFFICE DEORIA

Normlization is important for DBMS because It is a process of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the properties

(1).Minimizing redundancy, (2). Minimizing insertion, deletion and update anomalies.

Rami Nasr
par Rami Nasr , Analyst Programmer , AUC -The American University in Cairo -

Advantages 

 

1)Avoids data modification (INSERT/DELETE/UPDATE) anomalies as each data item lives in One place

 

2)Greater flexibility in getting the expected data in atomic granular

 

3)Normalization is conceptually cleaner and easier to maintain and change as your needs change

 

4)Fewer null values and less opportunity for inconsistency

 

5)A better handle on database security

 

6)Increased storage efficiency

 

7)The normalization process helps maximize the use of clustered indexes, which is the most powerful and useful type of index available. As more data is separated into multiple

tables because of normalization, the more clustered indexes become available to help

speed up data access.

 

Disadvantages 

 

1)Requires much more CPU, memory, and I/O to process thus normalized data gives reduced database performance

 

2)Requires more joins to get the desired result. A poorly-written query can bring the database down

 

3)Maintenance overhead. The higher the level of normalization, the greater the number of tables in the database.

More Questions Like This