> 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:
In response to
pgsql-novice by date
|Next:||From: Tony Griffiths||Date: 2002-06-18 08:24:14|
|Subject: Client-side libraries for fmgr invocation|
|Previous:||From: cmasters||Date: 2002-06-15 21:20:28|
|Subject: Fw: (orig posted to usenet) Advice req for restricting entry values]|
pgsql-general by date
|Next:||From: Dan Weston||Date: 2002-06-17 19:08:34|
|Subject: Re: TEXT and NULL...|
|Previous:||From: Joshua D. Drake||Date: 2002-06-17 18:43:58|
|Subject: Re: Clients for administration?|