November 5th, 2003, 12:46 AM
newbie to postgreSQL, having problems with database design
I've recently started learning PHP and PostgreSQL and find these forums very helpful. I really appreciate the help that experts such as you provide on the web. I am also learning the concepts behind database design and many of these terms ('normalisation', 'foreign keys', are new to me).
I do have a problem that none of the online references can seem to answer. The database I'm working on is a list of articles that appeared in our print publication. My problem is that the articles are to be classified using our cataloguing system of 24 standard descriptor words (ex., Culture, Education, Human Rights). However, most articles can have more than one descriptor word. I'm trying to think of the best way to cross-index the articles using a limited set of keywords.
I've created a table for the descriptor words but am at a loss on how to create the larger table that contains the article titles and so forth. Do I have to reflect multiple classification as multiple columns? Won't this be a redundancy? Since I will be querying this database with PHP, what could be an efficient design for our kind of classification scheme?
I really hope you can help.
November 5th, 2003, 07:13 AM