Oh yeah we've learned about the normal forms too :) It's all flying back into my mind right now ;o) Thx! > -----Original Message----- > From: Gregory Wood [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 27, 2001 5:04 PM > To: Christian Marschalek > Subject: Re: Supertypes? > > > > Well we've learned that when you have lets say five tables > which all > > contain name, adresse, city and so on you also have a form of > > redundancy... Can be wrong, though ;o) > > When dealing with relational databases, that redundancy (or > the process of eliminating it) is called normalization. This > usually involves breaking tables apart into smaller tables. > There are several 'normal forms' which database designers > strive for... each normal form is closer to the 'ideal' > database, although most designers don't bother with much > beyond 3rd normal form. Of course, it can be wise to break > the rules for performance reasons... > > Anyway, I highly recommend reading up on the topic... I > didn't when I first started playing with SQL and look back on > those days as my little database 'Dark Ages'. > > Greg > > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
