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.

1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?

3 Answers  

What is transact-sql language?

0 Answers  

What is acid mean in sql server?

0 Answers  

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

Explain what is lock escalation?

0 Answers  

What are the difference between clustered and a non-clustered index?

0 Answers  

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

How to modify an existing user defined function?

0 Answers  

How to count the number of duplicate items in a table?

3 Answers  

Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

Where is localdb stored?

0 Answers