Advantages:*
▪Any change to one record which is needed can instantly be made to any
related records
▪The database does not have redundant data making the file size smaller so
less money needs to be spent on storage
▪There is no data duplication so there are fewer errors in the data
▪Modifying a table is easier as there is less data to modify
*Disadvantages:*
🔸A larger number of tables requires more relationships to be designed taking
more time
🔸Making data atomic may not always be the best solution such as date of
birth can be separated into day, month and year but this may serve no
purpose
🔸Data may be stored as codes rather than meaningful data making it difficult
for humans to read/level of detail can be lost
🔸With more tables setting up queries can become more difficult
You can end up with more tables than an un-normalised database making it
difficult to keep track of data
🔸May require greater expertise (which may need to be bought in).
Comments
Post a Comment