Answer / shantanub

Normalization is the process of organizing data in a
database. This includes creating tables and establishing
relationships between those tables according to rules
designed both to protect the data and to make the database
more flexible by eliminating two factors: redundancy and
inconsistent dependency.

Answer / chethan sy

Normalization is a process of removing redundancy from the
tables.

De-normalization is introducing redundancy.

Answer / koti

In relational database design, the process of organizing
data to minimize redundancy. Normalization usually involves
dividing a database into two or more tables and defining
relationships between the tables. The objective is to
isolate data so that additions, deletions, and modifications
of a field can be made in just one table and then propagated
through the rest of the database via the defined relationships.

De-normalization is introducing redundancy.

Answer / srinivas

Normalization is the process of eliminating the duplicate , inconsistent data in the database..

As well denormalization is the process of introducing the redundancy to the data

Answer / hari

Normalization - is the process of desing of the datamodel
and effocential storre the data in database

Answer / ranjeet

normalization is used to remove data redundancy and
inconsitancy and we can perform the indexing,serching and
shorting the data in very easy manner

Answer / sarika desai

Normalization is a concept of Eliminating data redundancy,
Improve database performance & Index Improvement.

De-normalization is the process of attempting to optimize
the performance of a database by adding redundant data.

Answer / abdul quadir parihar

Normalization is the process of decomposition of complex
data in to simple way.

Denormalization is basically applied in the case the
database is over-normalised and no. of joins required to
fetch the data are too much. It is a purposeful redundancy
of some of the data to avoid the overhead of joins.

Answer / sandeep yadav

Normalization is the process of decomposition of complex
data in to simple way.
Denormalization is vice versa.

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

diffrence between function and procedure

5 Answers   Wipro,

What is the command used to get the version of sql server?

1 Answers  

what is Archive old data?

1 Answers  

How to convert character strings into numeric values?

0 Answers  

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  

What is difference between views and stored procedures?

0 Answers  

What are the disadvantages of using querystrings to send data from one page to another?

0 Answers  

What specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

Do you know exporting and importing utility?

0 Answers  

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

How do I trace a query in sql server?

0 Answers