What is normalization and what are the five normal forms?

Normalization is a design procedure for representing data in tabular format. The five normal forms are progressive rules to represent the data with minimal redundancy.
  • Interview Candidate
  • 1
  • 11300

Showing Answers 1 - 1 of 1 Answers

muamee

  • Jun 14th, 2010
 

Normalization in DB2 is used to reduce data redundancy and maintain integrity.
There are 4 types normalization
1st type: Every instances of an entiry should contain only one value.
2nd type: Each attribute which is not a primary key provides information that depends on the entire key.
3rd type: If each non-primary key gives a fact that is independent of other non-key attributes and dependent on key.
4th type: If no instances contain 2 or more independent multi-valued facts about an entity.

Give your answer:

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

 

Related Answered Questions

 

Related Open Questions