Advantages & Disadvantages Of Normalisation

Advantages & Disadvantages Of Normalisation

1. .More tables to join: By spreading data into more tables, this increase the need to join tables

   • Tables contain codes instead of real data: Repeated data is stored as codes .

2. Narrow tables: allows tables to have less columns and allows to fit more records per data page

   • Fewer indexes per table mean faster maintenance tasks such as index rebuilds.
     • less risk of mistakes
       • faster to run a query on the data

3. more tables the slower queries run

   • relationships are needed to interact with other table

4. pieces of information appear seperately when data is normalised

5. information is easier to find

   • helps reduce redundancy rates

6. normalisation also helps businesses

   • it pulls out all the abnormal factors to do with workers that do not fit in to the general consensus of the company.
     • this can help with recruting as it means only the suitable canidates would go through tothe interview process
       • this reduces the strain on the company and makes sure that the company get the best workers

7. time consuming

   • but a lot of companies use it as it is the easiest way to orgnaise large amounts of data

8. Normalisation can also be handy in finding anomalies within data.

   • For example, if an employee recently changed addresses, but only one of the databases that they are on is updated, normalisation would recognise this as abnormal and flag the issue up to human resources.
     • . The issue can then be rectified quickly and effectively by the human resources team simply updating the other databases.