Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Normilisation
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Normilisation
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
Gullanian View Drop Down
Senior Member
Senior Member
Avatar

Joined: 04 January 2002
Location: England
Status: Offline
Points: 4373 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Gullanian Quote  Post ReplyReply Direct Link To This Post Topic: Normilisation
    Posted: 17 September 2003 at 4:23pm

In college today we were doing database normilisation, there are four types as I understand, the first three are simple enough, but whats the fourth?  Im curious and can't find anything on google.  Closest I got to an answer was:

Quote A relation is in 4NF if it has no multi-valued dependencies.

Thanks for any answers!

Tom

 
Back to Top
eksimba View Drop Down
Groupie
Groupie


Joined: 23 April 2003
Location: United States
Status: Offline
Points: 48 		Post Options Post Options   Thanks (0) Thanks(0)   Quote eksimba Quote  Post ReplyReply Direct Link To This Post Posted: 17 September 2003 at 5:22pm

There's actually five normal forms, if I remember correctly. However, only the first 3 are used much; 4NF and 5NF are very specialized.

Doing a google search on "fifth normal form" yielded me tons of information...
- eric
Back to Top
Bluefrog View Drop Down
Senior Member
Senior Member


Joined: 23 October 2002
Location: Korea, South
Status: Offline
Points: 1701 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Bluefrog Quote  Post ReplyReply Direct Link To This Post Posted: 28 September 2003 at 8:08am

I've read about a 6th normal form, but that it is only theoretical.

The third normal form is really the only thing that we need to use. From there you can customize to suit your needs.

As far as it goes, I think I need to brush up on that as well. I forget everything past third.

 
Renegade Minds - Guitar Software Slow Down Music
Back to Top
anandsoft View Drop Down
Newbie
Newbie


Joined: 21 June 2003
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote anandsoft Quote  Post ReplyReply Direct Link To This Post Posted: 09 October 2003 at 2:01am

hello, check out the url:

http://www.cs.jcu.edu.au/Subjects/cp1500/1998/Lecture_Notes/ normalisation/contents.html

There is some good explanation, and examples given for fourth normal form. Hope this helps.

 
Back to Top
Bunce View Drop Down
Senior Member
Senior Member
Avatar

Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Bunce Quote  Post ReplyReply Direct Link To This Post Posted: 09 October 2003 at 5:15am

I always remember this:

"Normalise till it hurts.  De-normalise till it works"



Edited by Bunce
There have been many, many posts made throughout the world...
This was one of them.
Back to Top
Bluefrog View Drop Down
Senior Member
Senior Member


Joined: 23 October 2002
Location: Korea, South
Status: Offline
Points: 1701 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Bluefrog Quote  Post ReplyReply Direct Link To This Post Posted: 11 October 2003 at 2:47pm
Originally posted by Bunce Bunce wrote:

I always remember this:

"Normalise till it hurts.  Den-ormalise till it works"

I like that. It is so true.

 
Renegade Minds - Guitar Software Slow Down Music
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.