Re: databse design tutorial - Mailing list pgsql-general

From Ang Chin Han
Subject Re: databse design tutorial
Date
Msg-id 3F828592.2040000@bytecraft.com.my
Whole thread Raw
In response to Re: databse design tutorial  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
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

Attachment

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: concenation of strings and null values
Next
From: "Dieter Fischer (grid-it)"
Date:
Subject: Re: concenation of strings and null values