Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005

    Unanswered: Database design help

    Hi I was wondering if you could help me. I am currently trying to design a database. This database 4 tables, Main_Cat, Sub_Cat,SubSub_Cat and Prod_parent. How ever, not every sub_cat has a subsub_cat. And waas just wondering how I would link this.



    I have attached an image of what I have so far, if any one could help it would be greatly appreciated

    Attached Thumbnails Attached Thumbnails relationship.gif  

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    replace your 3 category tables with 1 hierarchical category table

    do a google search for adjacency model

    or see The recursive relationship (registration may be required, but it's free)
    Last edited by r937; 01-14-05 at 07:55. | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts