What is normalization and types of normalization?

Answer Posted / aa

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 ?    204 Yes 40 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by table in sql?

734


what is index? : Sql dba

765


What is meaning of <> in sql?

836


What is pl sql variable?

731


How do you exit in sql?

847


How do you change a value in sql?

775


What is sql*loader?

800


What are synonyms in sql?

763


Can we use pl sql in mysql?

743


how to check myisam tables for errors? : Sql dba

939


How to avoid duplicate records in a query?

778


What are pl sql data types?

760


What are different types of sql commands?

725


What is function and procedure in pl sql?

735


How are functions and procedures called in PL/SQL?

840