August 29, 2013 at 11:56 pm
can anybody explain me about 5 normal form ? I have searched the internet but I am not convinced!
please help
Thanks and Regards
August 30, 2013 at 8:12 am
Simply put, tables are in fifth normal form when they comply with fourth normal form and the table consists of a key attribute and a non-key attribute ONLY.
Francis
-----------------
SQLRanger.com
August 30, 2013 at 2:41 pm
August 30, 2013 at 3:21 pm
Francis Apel (8/30/2013)
Simply put, tables are in fifth normal form when they comply with fourth normal form and the table consists of a key attribute and a non-key attribute ONLY.
That's a remarkable idea - it seems to say that a table in 5NF can't have more than 2 attributes. Not surprisingly, that is not correct, for example a historized attribute table in Anchor Model (see the Wikipedia article on Anchor Modelling) has 3 attributes but is in (Date's version of) 6NF and hence also in 5NF.
Gurjer, did you look at the Wikipedia page on 5NF? If so, look at it again but instead of "travelling salesman" think "person with an agency agreement with one or more manufacturers", and instead of "telescope" think "hat stand" - you may well find that the example is much more believable like that, and that will perhaps make it easier to understand. If that doesn't help, say so in this forum and I'll try to find time to do a better explanation for you.
Tom
September 2, 2013 at 1:00 am
thank you all I think i got it
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply