What is Normalization ?
Answers were Sorted based on User's Feedback
Answer / kaushik dey
Normalization is a technique by this we can simplify any
entity-relationship data or information.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sachin
Normalization is a method of break down complex table’s
structure into simple table structure by using certain
rules. Normalization usually involves dividing a database
into two or more tables and defining relationships between
the tables. The objective of Normalization 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. With the help of this method we can reduce
redundancy in a table and remove the problems of
inconsistency and reduce the amount of space.
see more info on this link
http://www.mindstick.com/Articles/88d5a271-b369-4c0a-ae80-01e66df98b6a/?What%20is%20Normalization?
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / pratik maheshvari
normalization is the process of efficiently organizing data
in a database
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gaurav agrawal
Database normalization is a data design and organization
process applied to data structures based on rules that help
building relational databases. In relational database
design, the process of organizing data to minimize
redundancy is called normalization. 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.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / santhoshkavi
its a process of analysing the given relation schems based
on their functional dependencies and primary key to achieve
the properties
1.minimizing redundancy
2.minimizing insertion, deletion and update anamolies
types:
1NF
2NF
3NF
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / jagan
Normalization is the process of taking data from a problem
and reducing it to a set of relations while ensuring data
integrity and eliminating data redundancy
* Data integrity - all of the data in the database are
consistent, and satisfy all integrity constraints.
* Data redundancy – if data in the database can be found
in two different locations (direct redundancy) or if data
can be calculated from other data items (indirect
redundancy) then the data is said to contain redundancy.
Data should only be stored once and avoid storing data that
can be calculated from other data already held in the
database. During the process of normalization redundancy
must be removed, but not at the expense of breaking data
integrity rules.
If redundancy exists in the database then problems can arise
when the database is in normal operation:
* When data is inserted the data must be duplicated
correctly in all places where there is redundancy. For
instance, if two tables exist for in a database, and both
tables contain the employee name, then creating a new
employee entry requires that both tables be updated with the
employee name.
* When data is modified in the database, if the data
being changed has redundancy, then all versions of the
redundant data must be updated simultaneously. So in the
employee example a change to the employee name must happen
in both tables simultaneously.
The removal of redundancy helps to prevent insertion,
deletion, and update errors, since the data is only
available in one attribute of one table in the database.
The data in the database can be considered to be in one of a
number of `normal forms'. Basically the normal form of the
data indicates how much redundancy is in that data. The
normal forms have a strict ordering:
1. 1st Normal Form
2. 2nd Normal Form
3. 3rd Normal Form
4. BCNF
There are other normal forms, such as 4th and 5th normal
forms. They are rarely utilized in system design and are not
considered further here.
To be in a particular form requires that the data meets the
criteria to also be in all normal forms before that form.
Thus to be in 2nd normal form the data must meet the
criteria for both 2nd normal form and 1st normal form. The
higher the form the more redundancy has been eliminated.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / khartheek
Normalization is the process of decomping the realtions
into smaller realtions inorder to minimize the data
redudancy i.e (Repeation of same copies of data ) multiple
times .
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dhara
-> It is one of the most important concepts in the study of
the RDBMS.
->Tables that are hugged and bilky often defeat the purpose
of having an RDBMS all togather. This is because such
tables may not be easy to maintain.
->There are two ways of approching logical database design-
the top down approch
the botton up approch
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / naveen kumar bc a shiats
normlizaton is the process of simplifying the relationship
betweene data lements in a record
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / prinsha
it is a method for organizing data element in a database into table.it avoid duplication of data,insert anomaly,delete anomaly,update anomaly . 3 stage process first normal form,second normal form,third normal form
Is This Answer Correct ? | 0 Yes | 1 No |
How does the on-delete-cascade statement work?
What is meant by joins? List out the types of joins.
Explain what are the uses of rollback segment?
What is execute immediate in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What do you understand by database schema and what does it hold?
What is Network Database link ?
What is clusters ?
What is connection pool in oracle?
What would you do with an in-doubt distributed transaction?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
how to tune oracle sql queries pls tell me step by step. urgent pls