| From: | Ang Chin Han <angch(at)bytecraft(dot)com(dot)my> |
|---|---|
| To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: databse design tutorial |
| Date: | 2003-10-07 09:21:22 |
| Message-ID: | 3F828592.2040000@bytecraft.com.my |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tino Wildenhain | 2003-10-07 09:25:29 | Re: concenation of strings and null values |
| Previous Message | Dieter Fischer (grid-it) | 2003-10-07 09:20:14 | Re: concenation of strings and null values |