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

Do foreign keys improve performance?

543


what are the types of join and explain each? : Sql dba

530


What is %type in pl sql?

540


Explain the difference between cursor declared in procedures and cursors declared in the package specification?

575


Which normal form is best?

513






What are the three pl sql block types?

571


What is difference between mysql and postgresql?

511


What is data control language?

528


what is csv? : Sql dba

572


what is clause? : Sql dba

583


What are character functions in sql?

494


What are the types of operators available in sql?

552


Why truncate is used in sql?

527


What is sql mysql pl sql oracle?

567


what is “go” in t-sql? : Transact sql

598