GeekInterview.com
Series: Subject: Topic:
Question: 116 of 135

What is Normalization, First Normal Form, Second Normal Form , Third Normal Form


Answer posted by Badri Santhosh on 2005-05-18 09:40:29: Normalization : The process of decomposing tables to eliminate data redundancy is called Normalization. 
 
1N.F:- The table should caontain scalar or atomic values. 
2 N.F:- Table should be in 1N.F + No partial functional dependencies 
3 N.F :-Table should be in 2 N.F + No transitive dependencies
Asked by: Interview Candidate | Asked on: Jul 28th, 2005
Showing Answers 1 - 6 of 6 Answers
Badri Santhosh

Answered On : May 18th, 2005

Normalization : The process of decomposing tables to eliminate data redundancy is called Normalization.  1N.F:- The table should caontain scalar or atomic values. 2 N.F:- Table should be in 1N.F + No partial functional dependencies 3 N.F :-Table should be in 2 N.F + No transitive dependencies

Yes  1 User has rated as useful.
  
Login to rate this answer.
ramesh

Answered On : Jun 7th, 2005

2NF - table should be in 1NF + non-key should not dependent on subset of the key ({part, supplier}, sup address)  3NF - table should be in 2NF + non key should not dependent on another non-key ({part}, warehouse name, warehouse addr)  {primary key}  more... 4,5 NF - for multi-valued dependencies (essentially to describe many-to-many relations)

  
Login to rate this answer.
murali

Answered On : Jul 28th, 2005

Yes  2 Users have rated as useful.
  
Login to rate this answer.
ravi kumar guturi

Answered On : Mar 9th, 2006

Normalization is a process of remove the retundancy and inconsistencyMainly 3 normal forms1normal form: Here contain only atomic values2normal form:The nonkey values must be depend upon the primary key3normal form:not depended on transitivity

  
Login to rate this answer.
Jyothsna Tallapally

Answered On : May 10th, 2006

Normalization:It is the process of efficiently organizing data in a database.There are 2-goals of the normalization process: 1. Eliminate redundant data 2. Ensure data dependencies make sense(only storing related data in a table)First Normal Form:It sets the very basic rules for an organized database. 1. Eliminate duplicate columns from the same table 2. Create separate tables for each group of related data and identify each row with a unique column or set of columns.Second Normal Form:Further addresses the concept of removing duplicative data. 1.Remove subsets of data that apply to multiple rows of a table and place them in a separate tables. 2.Create relationships between these new tables and their predecessors through the use of foreign keys.Third Normal Form: 1.Remove columns that are not dependent upon the primary key.Fourth Normal Form: 1.A relation is in 4NF if it has no multi valued dependencies.These normalization guidelines are cumulative.For a database to be in 2NF, it must first fulfill all the criteria of a 1NF database.

Yes  1 User has rated as useful.
  
Login to rate this answer.
dstorkey

Answered On : Mar 24th, 2009

View all answers by dstorkey

To paraphrase the oath, and help you remember, in 3rd normal form data in the table depends on the key, the whole key, and nothing but the key.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.