Answer Posted / anjana
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 ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the types of database recovery models?
How dts is used to extract, transform and consolidate data?
Is it important for a database administrator to understand the operating system and file access?
List out a number of the wants to setup a SQL Server failover cluster?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What are character string data types in ms sql server?
How to add additional conditions in SQL?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
what are the important architecture components of SSRS?
What are the different types of replication you can set up in sql server?
Explain different types of Normalization.
Data table as parameter in sql server?
What are statistics?
What is page in sql server?
What is difference between Datepart() and Datename() in SqlServer?