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.
Product which can be manufactured by various
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
Sweets should be manufactured by
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 |