Exam 98-364 topic 1 question 45 discussion

Denormalization is a database optimization technique in which we add redundant data to one or more tables. This can help us avoid costly joins in a relational database.

Denormalization is a strategy used on a previously-normalized database to increase performance. In computing, denormalization is the process of trying to improve the read performance of a database, at the expense of losing some write performance, by adding redundant copies of data or by grouping data.

https://www.techtarget.com/searchdatamanagement/definition/denormalization#:~:text=Denormalization%20is%20the%20process%20of%20adding%20precomputed%20redundant,a%20database%20requires%20data%20has%20first%20been%20normalized.

B. Eliminate repeating groups. There are five normalization forms (NFs), of which we’ll focus on the first three: • First normalization form (1NF): Eliminate repeating groups • Second normalization form (2NF): Eliminate redundant data • Third normalization form (3NF): Eliminate columns not dependent on key • Fourth normalization form (4NF): Isolate independent multiple relationships • Fifth normalization form (5NF): Isolate semantically related multiple relationships