Answer / koti-khammam

It is the process of removing redundancy(repeated data) by
splitting the tables into smaller tables.

Answer / anirudh

Normalization is breaking the database into different
tables and defining a relationship between them.
Objective is to isolate the data so that additions and
deletions can be made in one table and propagated to other
tables through relationships.

Answer / shruti

Normalization is the process of breaking tables of a
database into smaller tables and defining relations between
them to make them more flexible, efficient and to remove the
modification anamolies from the database.

Answer / kranthi

Normalization is the process of structuring relational
database schema such that most ambiguity is removed. The
stages of normalization are referred to as normal forms and
progress from the least restrictive (First Normal Form)
through the most restrictive (Fifth Normal Form).

Answer / 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

Answer / padmapriya

Noramalization is process of breaking the information into
well defined tables which should follow some rules. There
are 5 Normal forms available. Each one having a separate
rule.
1NF-Avoid redundant data
2NF-All coulms except primary key column should be related
to the primary key column
3NF,4NF and 5NF - I'dont remember , if any one knows please
reply

Answer / maskfriend

Normalize the data from the detabase.It reduces by the
normalisation rule like(there are 4 normalization rule and
BCNF)

What is a linked server in sql server?

0 Answers  

How to modify an existing user defined function?

0 Answers  

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

Define candidate key, alternate key, and composite key.

0 Answers  

What is transact-sql language?

0 Answers  

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers  

What the different components in replication and what is their use?

0 Answers  

How sql server enhances scalability of the database system?

0 Answers  

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

Do comments need to go in a special place in sql server 2005?

0 Answers  

When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,