Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

What is normalization and its forms?

Answers were Sorted based on User's Feedback

What is normalization and its forms?..

Answer / sd

Normalization is process of reducing redundancy of a
database , by decomposing the database into several smaller
files ( tables) and using the concept of codification

Forms 1NF,2NF,#NF , boyce codd NF

Is This Answer Correct ?    28 Yes 3 No

What is normalization and its forms?..

Answer / rohit

Database normalization, sometimes referred to as canonical
synthesis, is a technique for designing relational database
tables to minimize duplication of information and, in so
doing, to safeguard the database against certain types of
logical or structural problems, namely data anomalies. For
example, when multiple instances of a given piece of
information occur in a table, the possibility exists that
these instances will not be kept consistent when the data
within the table is updated, leading to a loss of data
integrity. A table that is sufficiently normalized is less
vulnerable to problems of this kind, because its structure
reflects the basic assumptions for when multiple instances
of the same information should be represented by a single
instance only.

Higher degrees of normalization typically involve more
tables and create the need for a larger number of joins,
which can reduce performance. Accordingly, more highly
normalized tables are typically used in database
applications involving many isolated transactions (e.g. an
automated teller machine), while less normalized tables tend
to be used in database applications that need to map complex
relationships between data entities and data attributes
(e.g. a reporting application, or a full-text search

Database theory describes a table's degree of normalization
in terms of normal forms of successively higher degrees of
strictness. A table in third normal form (3NF), for example,
is consequently in second normal form (2NF) as well; but the
reverse is not necessarily the case.

Although the normal forms are often defined informally in
terms of the characteristics of tables, rigorous definitions
of the normal forms are concerned with the characteristics
of mathematical constructs known as relations. Whenever
information is represented relationally, it is meaningful to
consider the extent to which the representation is normalized.

Is This Answer Correct ?    9 Yes 4 No

What is normalization and its forms?..

Answer / srinivas

Normalization is the process of splitting the table into
multiple subtables based on their functional dependency.

Forms are First normal form, Second normal form, and Third
normal form.

Is This Answer Correct ?    10 Yes 10 No

What is normalization and its forms?..

Answer / hepsi

normalization is the process of analysing relational schema based on their functional dependency and primary key to achieve properties like minimizing redundancy,minimizing insertion,deletion,updation anomalies.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Write a SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

How to find table changes in sql server?

0 Answers  

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

What is single-user mode?

0 Answers  

Explain transaction server auto commit?

0 Answers  

Which are new data types introduced in sql server 2008?

0 Answers  

What are transactions and its controls?

0 Answers  

What are the properties of primary key?

0 Answers  

What is the command to change the recovery model?

0 Answers  

Do you know exporting and importing utility?

0 Answers