Normalization and denormalization

Answer Posted / sakthi

Normalization:
Process of decomposing a longer table into
smaller one, by using normalizaton we can fetch the data
faster. there are different types of normalization below
listed are few important one.

1) 1st normal form
2) 2nd normal form
3) 3rd normal form
4) 4th normal form
5) 5th normal form

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is service broker? : sql server database administration

742


Explain insert into select statement?

689


What is the chart in report?

125


What are the benefits and tasks of object explorer? : sql server management studio

799


How to find index size for each index on table?

769






What is the difference between migration and upgradation in sql server?

796


Introduction of rollup clause using sum and group by clause?

704


What is statement level trigger?

753


How do I connect to sql server database?

685


Explain the truncate command?

680


Can sql servers link to other servers?

752


How to create indexed view?

733


Can you get second highest salary from the table?

724


What is auditing in sql server?

688


How to use union to merge outputs from two queries together in ms sql server?

751