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
How do I limit the number of rows returned by an oracle query after ordering?
Is postgres faster than oracle?
What happens to the current transaction if the session is ended?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Explain mutating triggers.
Difference between varchar and varchar2 data types?
Explain what are clusters?
What does sharding mean?
What are the types of trigger in oracle?
What are oracle functions?
Can we create database in oracle using command line ?
Explain an exception?
How many types of cluster table in Oracle?
Explain about the analyze command in oracle?
How to create a temporary table in oracle?