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

how many no of arguments can be passed in procedures and functions

4787


How can we call UDF(User Define Function) using C# code in ASP.net ?

5946


What is coalesce in sql server?

539


What are the main sources of data?

601


Distinguish between nested subquery and correlated subquery?

550






What is factless fact table? : sql server analysis services, ssas

565


Why it is recommended to avoid referencing a floating point column in the where clause?

542


What are the steps you will take to improve the performance of a poor performing query?

599


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5504


What are the tables in sql?

630


What command is used to create a database in the sql server and how?

606


What is the difference between local and global temporary tables?

591


Explain what is use of dbcc commands?

515


How to provide column names in insert statements in ms sql server?

609


what are cursors? : Sql server database administration

517