What is the difference between Normalization and Denormalization in SQL?

Question

Could someone tell me what is the difference between Normalization and Denormalization in SQL?

Answer 1

Both methods are used in a SQL database. Normalization is used when the database should be clear of redundancy, and any inconsistent data. By applying this technique, the non-redundant and consistent data are stored in the set schema. Whereas Denormalization is used when we have little time to execute the query. Essentially what happens is that data is combined, and even redundant data together to perform execution of query quickly. Both methods are opposite to each other. And Normalization increases the total number of tables, and Denormalization decreases the number of tables. If you are searching out for a good course in SQL, check out Intellipaat’s SQL training course, and watch the following video on SQL Tutorial to get your fundamentals correct.