#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    Manila, Philippines
    Posts
    3
    Rep Power
    0

    Unhappy 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.

    Best regards

    Aileen Familara
    Isis International-Manila
    http://www.isiswomen.org
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,146
    Rep Power
    4274
    oh! oh! i know! i know!

    there's a great answer here -- http://forums.devshed.com/t96199/s.html

IMN logo majestic logo threadwatch logo seochat tools logo