Which Is Not An Advantage Of Data Normalization?

The advantages of database normalisation are that information technology makes the procedure of changing the data in a tabular array for a lot if its components easier, because normalising a database enables the user to create human relationship strands between the pieces of information. Like pieces of information will announced in a carve up, smaller table when a database is normalised. This is also an advantage of normalisation considering it means that you can easily find like pieces of data within a table.
Normalisation helps to reduce redundancy rates within companies because when a database is normalised, it pulls out all the abnormal factors to do with workers that do not fit in to the full general consensus of the visitor. This can help when recruiting personnel, because it means that only the suitable candidates go through to interview in the showtime place, lessening the strain on company resources but at the same time making certain that the company gets the very best workers.
Normalisation tin can besides be handy in finding anomalies within data. For example, if an employee recently changed addresses, simply only one of the databases that they are on is updated, normalisation would recognise this every bit abnormal and flag the upshot up to human resources. The issue tin then be rectified speedily and effectively by the human resources team merely updating the other databases.
Normalisation too has its disadvantages, though. It tin can be very difficult and time consuming to input the relevant formulas to get the database to function properly, simply if you lot are competent with computing this should not exist besides much of an issue.
Normalisation is used in well-nigh all big company databases because it is the easiest way to organise large scores of data. It has a lot more advantages than disadvantages for the companies that utilise it.

Advantages

ane) Avoids data modification (INSERT/DELETE/UPDATE) anomalies as each information particular lives in One place

2) Greater flexibility in getting the expected information 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 blazon of alphabetize available. Every bit more information is separated into multiple
tables considering of normalization, the more amassed indexes get available to help
speed up data access.

Disadvantages

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

two) Requires more joins to go the desired event. A poorly-written query can bring the database down

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

Advantages
•Avoids data modification (INSERT/DELETE/UPDATE) anomalies as each data detail lives in One place
•Greater flexibility in getting the expected information in atomic granular
•Normalization is conceptually cleaner and easier to maintain and change every bit your needs alter
•Fewer nada values and less opportunity for inconsistency
•A better handle on database security
•Increased storage efficiency
•The normalization procedure helps maximize the use of clustered indexes, which is the nearly powerful and useful type of alphabetize available. Every bit more than data is separated into multiple tables considering of normalization, the more clustered indexes become bachelor to assist speed up data access
Disadvantages
•Requires much more CPU, retentivity, and I/O to process thus normalized data gives reduced database functioning
•Requires more joins to get the desired result. A poorly-written query tin can bring the database down
•Maintenance overhead. The higher the level of normalization, the greater the number of tables in the database.