Sample Header Ad - 728x90

Are updates the only disadvantage of denormalization?

2 votes
3 answers
620 views
I am trying to understand what are the disadvantages of denormalization. Say that I have the following database (School_has_Student is a denormalized table): enter image description here I have read that the problems that you may face when using denormalization are related to the operations of INSERT, UPDATE, and DELETE. Now I understand why we have the UPDATE problem, because if I updated one piece of data, then I would have to update the rest of the related pieces of data (for example: if I updated the student name "Paul" in the Student table, then I would have to also update the student name "Paul" that exist two times in the School_has_Student table), but I don't understand why INSERT and DELETE are also problems. Note: I know that the increase of storage space is also a disadvantage, but I do not think it is a big disadvantage with current storage devices which have very large capacity.
Asked by Tom (129 rep)
Oct 19, 2018, 10:24 AM
Last activity: Nov 25, 2019, 08:47 PM