From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | cmasters(at)nbnet(dot)nb(dot)ca, pgsql-nov <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Fw: (orig posted to usenet) Advice req for restricting entry values] |
Date: | 2002-06-17 19:02:34 |
Message-ID: | 200206171202.34997.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
C. Masters,
> I'm attempting to design a database for use in a library (loan) setting.
> Although I'm a novice psql user, I have had previous experience in data
> mangement during the "good 'ol" text entry days.
>
> Several of the fields have a limited set of possible values; as such, I
> would like to automate the initial population and subsequent entry of new
> records -- fields such as 'media', 'genre', 'interest', etc. I'd like
> some input regarding the most effective way to accomplish this task.
The relational way to do this is with reference tables and a Foriegn Key
constraint. Any good book on SQL database design will help you do this:
http://techdocs.postgresql.org/techdocs/bookreviews.php
--
-Josh Berkus
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Weston | 2002-06-17 19:08:34 | Re: TEXT and NULL... |
Previous Message | Joshua D. Drake | 2002-06-17 18:43:58 | Re: Clients for administration? |
From | Date | Subject | |
---|---|---|---|
Next Message | Tony Griffiths | 2002-06-18 08:24:14 | Client-side libraries for fmgr invocation |
Previous Message | cmasters | 2002-06-15 21:20:28 | Fw: (orig posted to usenet) Advice req for restricting entry values] |