What is normalization?

Answer Posted / anjana

Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data (for example, storing
the same data in more than one table) and ensuring data
dependencies make sense (only storing related data in a
table). Both of these are worthy goals as they reduce the
amount of space a database consumes and ensure that data is
logically stored.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain forward - only cursors?

703


What is 2nf normalization?

733


When does a workload on SQL Azure get throttled?

127


What are ddl triggers and types of ddl trigger?

787


What is the security principal at the database level that represents your session?

702






What different steps will a sql server developer take to secure sql server?

722


What should be the fill factor for indexes created on tables? : sql server database administration

816


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1713


Is it possible for a stored procedure to call itself or recursive stored procedure?

719


What is PROJECTION Operation?

767


Explain nested trigger in sql?

762


Explain what are the authentication modes in sql server?

678


When we should use and scope of @@identity?

718


What is a rollup clause?

715


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

794