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
What is not equal to in oracle?
Is postgres faster than oracle?
Can we create trigger on materialized view in oracle?
How many types of segments in Oracle?
Explain constraining triggers.
Please explain oracle left join with an example?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How will you differentiate between varchar & varchar2?
What is the database name in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
How to use regular expression in pattern match conditions in oracle?
Explain the use of grant option in exp command.
How to create an oracle testing table?
How to get a list of all user accounts in the database?
How to upsert (update or insert into a table)?