Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (42.8k points)

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

1 Answer

0 votes
by (96.1k points)

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.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Oct 20, 2020 in SQL by dev_sk2311 (42.8k points)
0 votes
1 answer
asked Oct 19, 2020 in SQL by dev_sk2311 (42.8k points)
0 votes
1 answer

Browse Categories

...