Thread: databse design tutorial

Nagib Abi Fadel wrote:

> Hi everybody,
>
> i need a free tutorial on database design can any help ??

How about "A Simple Guide to Five Normal Forms in Relational Database
Theory, Communications of the ACM 26(2), Feb. 1983":

http://209.197.234.36/db/simple.html

Mike Mascari
mascarm@mascari.com

On Mon, 2003-10-06 at 16:52, Mike Mascari wrote:
> Nagib Abi Fadel wrote:
>
> > Hi everybody,
> >
> > i need a free tutorial on database design can any help ??
>
> How about "A Simple Guide to Five Normal Forms in Relational Database
> Theory, Communications of the ACM 26(2), Feb. 1983":
>
> http://209.197.234.36/db/simple.html

Note that, the vast majority of the time, and especially for young
DBAs, only the 1st 3 NFs are necessary.

Thanks for the link.

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

"Whatever may be the moral ambiguities of the so-called demoratic
nations and however serious may be their failure to conform
perfectly to their democratic ideals, it is sheer moral
perversity to equate the inconsistencies of a democratic
civilization with the brutalities which modern tyrannical states
practice."
Reinhold Nieburhr, ca. 1940

Ron Johnson wrote:
>>>Hi everybody,
>>>
>>>i need a free tutorial on database design can any help ??

On the slightly more intermediate level to db design would be:

http://www.therationaledge.com/rosearchitect/mag/archives/9904/RATL-2.PDF

It is written from the perspective of Object Oriented Programming, so it
might be a better starting point for those with more OO experience.

Especially useful are points on:
  - Discussions on Existence-based (sequences) vs Value-based (real world
    value) primary keys
  - Different approaches to handling enums
  - Discouraging designs that leads to huge number of columns
  - Various implementations of associations
  - Implementing inheritance (alas, not pgsql's)

--
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
   5:00pm  up 285 days,  8:32, 10 users,  load average: 6.13, 6.12, 6.12