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 to loop through a cursor variable?
WHAT IS ecc 6.0
What is the difference between hot backup and cold backup in oracle?
How to assign values to data fields in record variables?
What is oracle analytical function?
What is difference between truncate and delete?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How to set up autotrace for a user account?
What are the oracle differences between nvl and coalesce
How to select an oracle system id (sid)?
What happens to the current transaction if the session is killed?
Who developed oracle & when?
Explain how you would restore a database using RMAN to Point in Time?
How to call a sub procedure?
please explain.. DB architecture ...