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 the difference between count(*) and count(1) ?

635


What are the new features are introduced in sql server 2012 reporting services?

109


Explain the types of indexes.

651


Can we insert data into view sql server?

520


What is sparse columns of sql server 2008?

610






create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

507


If user is owning any SQL Objects, can we drop that user

1612


What is the difference between seek predicate and predicate?

594


What is role playing dimension with two examples? : sql server analysis services, ssas

601


what is checksum in sql server.........???

1211


Detail about the hardware which is supported by SQL server?

597


How to create a view using data from another view?

574


What are sql server functions?

526


What is the ‘fillfactor’?

573


In which tcp/ip port does sql server run? Can it be changed?

558