What is Normalization ?

Answer Posted / deep

Normalization means "The imposition of standards or
regulations". In the context of Relational Database Systems,
Database Normalization specifies a set of rules that splits
up a relational schema into a number of smaller subschemas,
in the objective of eliminating database anomalies. Database
normalization ensures that the data integrity and
consistency of the database is maintained. Each table in a
relational schema has a highest normal form indicating the
table's degree of vulnerability to logical inconsistencies
and anomalies. Database Normalization defines the steps to
decrease the degree of vulnerability in database systems.
Edgar F. Codd, the inventor of the relational model,
introduced the concept of normalization which is carried out
by the database designer of relational systems.
To determine and to achieve a highest normal form of
database systems please read
http://basudip.hubpages.com/hub/Database-Normalization

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is not equal to in oracle?

528


Is postgres faster than oracle?

561


Can we create trigger on materialized view in oracle?

565


How many types of segments in Oracle?

529


Explain constraining triggers.

595






Please explain oracle left join with an example?

585


Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1656


How will you differentiate between varchar & varchar2?

591


What is the database name in oracle?

534


How do I limit the number of rows returned by an oracle query after ordering?

635


How to use regular expression in pattern match conditions in oracle?

575


Explain the use of grant option in exp command.

586


How to create an oracle testing table?

591


How to get a list of all user accounts in the database?

616


How to upsert (update or insert into a table)?

539