From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
---|---|
To: | Postgres Admin List <pgsql-admin(at)postgresql(dot)org> |
Subject: | proper db standard |
Date: | 2002-12-06 15:45:46 |
Message-ID: | 005a01c29d3e$8ad6c7a0$de138f80@virginia.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I am creating a simple database that will hold information about various publications. There are keywords that are associated with these publications and there can be anywhere from 1 to about 6 of these different keywords.
As I see it I have two choices:
1) create keyword fields 1-6 in the publications database and accept that some of these fields will be empty.
2) create two tables: "publication" and "keyword". In this scenario I have no limit on the amount of keywords that are used and I don't have empty fields. However, many of the keywords repeat for different publications. In this situation I would have some repeating words in the columns.
I lean toward #2 but wanted to see if there was a preferred standard or another possibility that I am overlooking??
Thanks
Jodi
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Langille | 2002-12-06 16:02:09 | Re: proper db standard |
Previous Message | Peter Childs | 2002-12-06 06:03:23 | Re: list schema |