Re: relationship/table design question

 Taylor Lewick wrote:

> Hi all, new to postgresql and I have a question about
> how to lay out my database.

Being new to Postgress is of no consequence. If, however,
you are new to database design, there are many texts on
the web that cover the subject, better and in more detail
than a post such as this could do. A quick search turned
up the following:

http://databases.about.com/library/weekly/aa080501a.htm
http://databases.about.com/library/weekly/aa081901a.htm
http://databases.about.com/library/weekly/aa090201a.htm
http://databases.about.com/library/weekly/aa091601a.htm

Read those, in order. Keep tables in third normal form,
unless you have some good, quantifiable reason for not
doing so.

Congratulations, you are now a database design expert.

cheers,
Roger