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 many types of segments in Oracle?
How will you identify oracle database software release?
What is a oracle database?
Which is better Oracle or MS SQL? Why?
What is the simplest tool to run commands on oracle servers?
What are the set operators union, union all, minus & intersect meant to do?
How does oracle handle read consistency?
What are the attributes of cursor?
How to write date and time literals in oracle?
Can a formula column be obtained through a select statement ?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
11. Display the client number and name and the client number and name of the person who referred that client.
What is a system tablespace?
Explain the use of grant option in exp command.
What is an oracle user role?