What is the meaning of Data Normalization?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the meaning of Data Normalization?

Data Normalization is the process of reducing data to its canonical form. It is usually a process of breaking a table of a large number of columns into multiple tables with less columns in each table and using foreign keys to estalish relations them.

(Continued on next question...)

Other Job Interview Questions

• What is "bcp"?
• What does Trigger refers to in MS SQL Server?
• What is the meaning of Data Normalization?
• What is the meaning of an Inner Join operatin of two tables?
• What is the meaning of an Outer Join operatin of two tables?
• If you finish installing MS SQL Server as Named Instance, what would be the default path name on the hard disk where the server will be installed to?
• What is the size of an Extent in MS SQL Server?
• What is the difference between a Default Instance and a Named Instance of MS SQL Server?
• What two categories you can divide T-SQL statements into?
• What does Trigger refers to in MS SQL Server?
• More...