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 are the types of table?

549


Describe in brief authentication modes in sql server.

570


How to write a query with a full outer join in ms sql server?

564


Characterize join and name diverse sorts of joins?

533


How to delete existing triggers using "drop trigger"?

560






You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

488


How many tables can be joined in SQL Server?

594


What is the openxml statement in sql server?

538


What is spatial and temporal data?

536


explain different levels of normalization? : Sql server database administration

525


Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

499


What is the use of keyword with encryption. Create a store procedure with encryption?

587


What is the temp table?

546


What do you mean by an execution plan? Why is it used? How would you view it?

534


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

702