Can you Explain Fifth Normal Form?

 Posted by ArticlesMaint on 9/18/2009 | Category: Sql Server Interview questions | Views: 9076

Note: - UUUHHH if you get this question after joining the company, do ask him if he himself really uses it?

Fifth normal form deals with reconstructing information from smaller pieces of information. These smaller pieces of information can be maintained with less redundancy.

Example: Dealers sell Product which can be manufactured by various Companies. Dealers in order to sell the Product should be registered with the Company. So these three entities have a mutual relationship within them.

Not in Fifth Normal Form.

The above table shows some sample data. If you observe closely, a single record is created using lot of small information. For instance: JM Associate can sell sweets under the following two conditions:

  • JM Associate should be an authorized dealer of Cadbury

  • Sweets should be manufactured by Cadbury company

These two smaller bits of information form one record of the above given table. So in order for the above information to be “Fifth Normal Form” all the smaller information should be in three different places. Below is the complete fifth normal form of the database.

 Complete Fifth Normal Form

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response