Interested to Buy Any Domain ? << Click Here >> for more details...
What is Normalization ?
- 55 Answers
- 89492 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
How do we display rows from the table without duplicates?
How to invoke the data pump export utility?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
How to specify default values in insert statement using oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
What are privileges and grants?
what is the scripts in data base?
How to rename a tablespace in oracle?
How to pass parameters to procedures?
What is the usage of control file in oracle?
How to rollback the current transaction in oracle?
How view is different from a table?
What is a dynamic performance view in oracle?
How to create an initialization parameter file?
How to drop an index?
