what is normalization?
what is denormalization?

Answer Posted / srinivas

Normalization is the process of eliminating the duplicate , inconsistent data in the database..

As well denormalization is the process of introducing the redundancy to the data

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

700


What is the difference between web edition and business edition?

103


How does clustered and non clustered index work?

679


do you know how to configure db2 side of the application? : Sql server database administration

783


What is policy based management (pbm)? : sql server database administration

739






Can you explain the disadvantages/limitation of the cursor?

674


What is multi-statement table-value user-defined function?

724


What languages bi uses to achieve the goal?

691


How can you know if the row fetched from cursor is still valid in underlying table?

756


Can you please differentiate between a primary key and a unique key?

723


What are the types of sql server?

699


When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

860


What is the default order of an order by clause?

778


What is database dimension? : sql server analysis services, ssas

835


How to find the login name linked to a given user name?

673