Register now or log in to join your professional community.
Why its a requirement that a system should be normalized and it will give best results regarding fetching data in form of reports
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.
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.
