What is Normalization ?
- 55 Answers
- 74103 Views
- ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault, I also Faced
- E-Mail Answers
Answer Posted / shivag
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
What is a parameter file in oracle?
What is meant by joins? List out the types of joins.
What is dynamic proxy?
What does sharding mean?
How to empty your oracle recycle bin?
How to find the duplicate rows count from employees table in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
How to divide query output into groups in oracle?
What is SQL Tuning Advisor in Oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How can I get column names from a table in oracle?
How is it different from a normal table?
What is a system tablespace and when it is created?
How to start your 10g xe server from command line?
Calculate difference between 2 date / times in oracle sql?
