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 query editor regions

612


What are security principals used in sql server 2005?

513


What are the different types of cursor?

603


Explain multiserver query

551


Is sql server implemented as a service or an application? : Sql server database administration

509






Where in ms sql server is ’100’ equal to ‘0’?

596


What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

117


Explain go command in sql server?

543


Explain about unique identifier data type in sql server?

508


Which tcp/ip port does sql server run on? How can it be changed?

567


What is ddl command?

529


Who developed sql server?

526


What is unique key constraint?

628


Do you know the different ddl commands in sql?

589


Can you explain what is sql server english query?

539