What is Normalization ?
- 55 Answers
- 74101 Views
- ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault, I also Faced
- E-Mail Answers
Answer Posted / gopal sharma
In the field of relational database design, normalization is a systematic way of ensuring that a database structure is suitable for general-purpose querying and free of certain undesirable characteristics—insertion, update, and deletion anomalies—that could lead to a loss of data integrity.[1]
Database normalization is a technique for designing
relational database tables to minimize duplication of
information and, in so doing, to safeguard the database
against certain types of logical or structural problems,
namely data anomalies.
For example, when multiple instances of a given piece of
information occur in a table, the possibility exists that
these instances will not be kept consistent when the data
within the table is updated, leading to a loss of data
integrity. A table that is sufficiently normalized is less
vulnerable to problems of this kind, because its structure
reflects the basic assumptions for when multiple instances
of the same information should be represented by a single
instance only.
The formal classifications describing the level of database
normalization in a data model are called Normal Forms (NF)
and the process of doing this is Normalization.
First normal form :
• A table is in first normal form when it contains no
repeating groups.
• The repeating column or fields in an un normalized table
are removed from the table and put in to tables of their own.
• Such a table becomes dependent on the parent table from
which it is derived.
• The key to this table is called concatenated key, with the
key of the parent table forming a part it.
Second normal form:
• A table is in second normal form if all its non_key fields
fully dependent on the whole key.
• This means that each field in a table ,must depend on the
entire key.
• Those that do not depend upon the combination key, are
moved to another table on whose key they depend on.
• Structures which do not contain combination keys are
automatically in second normal form.
Third normal form:
• A table is said to be in third normal form , if all the
non key fields of the table are independent of all other non
key fields of the same table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert characters to times in oracle?
What is format trigger?
What is a sub query? What are its various types?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How a tablespace is related to data files?
How to define default values for formal parameters?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is a nested table and how is it different from a normal table?
How to create a table index?
List out the types of joins.
What is the difference between view and materialized view in Oracle?
How will you differentiate between varchar & varchar2?
How to view the data files in the current database?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is oracle open database communication (odbc)?
