adspace


Explain Normalization and DE normalization

Answer Posted / Nitin Kumar Sharma

Normalization is a process to organize data in a database to reduce redundancy and improve efficiency. It involves several normal forms (1NF, 2NF, 3NF, etc.). De-normalization is the opposite process, where redundant data is intentionally introduced for performance or convenience reasons.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where can you add custom error messages to sql server?

1215


How can we solve concurrency problems?

1123


Can sql servers link to other servers like oracle?

919


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1024


How can I check that whether automatic statistic update is enabled or not?

1113


Why use identity in sql server?

1203


What is a scheduled job or what is a scheduled task?

1040


What is normalization and what are the advantages of it?

1057


How to convert character strings into numeric values?

1192


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8232


What are the source of constraints?

1010


What is self contained sub query?

1141


How do I start sql server 2017?

1016


What are wait types?

1251


What is the difference between for xml raw and for xml auto?

1119