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

Explain tables in SQL Azure?

96


Explain full-text indexing?

516


How we can refresh the view?

597


How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

539


What is the purpose of indexing?

598






Explain what are the different index configurations a table can have?

694


What is the template in sql?

539


How much does sql server 2016 cost?

537


Does order by actually change the order of the data in the tables or does it just change the output?

680


What is xml datatype?

659


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1470


How many clustered indexes there can be on table ?

602


Difference between Inner vs outer joins?

535


Do you know what is fill factor and pad index?

569


Your table has a large character field there are queries that use this field in their search clause what should you do?

505