What is database normalization?

Answer Posted / dr. tawfik khattab

Normalization is the process of efficiently organizing data
in a database.
The goals of the normalization process asfollows:
1- Eliminating redundant data
2- Ensuring data total dependence on the Pk or on the
Composite PK

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the benefit of normalization?

598


How to backup encryption key ?

127


What is self contained scalar sub query?

545


List the various tools available for performance tuning?

490


What are the advantages of policy management?

590






How do you set a trace flag in sql server?

567


What do you mean by SQL injection attack?

630


Can primary key be a foreign key?

574


What is SQL Azure Federations?

98


Why we need sql server?

569


Write an sql query for deleting duplicate rows?

559


What are the differences between user defined functions and stored procedures?

539


What is an index. What are the types?

592


How to view existing indexes on an given table using sys.indexes?

608


What is rank function?

614