Design dilemma I can't get past
From: WebGuyBill <bill_at_bhmediagroup.com>
Date: 28 Dec 2002 20:37:21 -0800
Message-ID: <1a7d5f0d.0212282037.274bc5f5_at_posting.google.com>
Hello -- I'm a self-taught newbie. I appreciate any help you can offer.
Date: 28 Dec 2002 20:37:21 -0800
Message-ID: <1a7d5f0d.0212282037.274bc5f5_at_posting.google.com>
Hello -- I'm a self-taught newbie. I appreciate any help you can offer.
Using MySQL and PHP I'm designing a database for my website, which is all about books. My database structure is going to wind up being very similar to Amazon (tables for Authors, Titles, graphics, etc).
Where I'm having trouble is with Categories (or Genres). Any one book can typically fall into as many as 8-to-10 categories. How best can I relate a specific title (e.g. "Moby Dick") to more than one category (e.g. "Literature > Thrillers > Seafaring" as well as "Animals > Mammals > Whales")?
Do I need separate tables for each primary category (Biography, History, et al) and then more separate tables for each sub-category and sub-sub-category?
Thanks so very much for any help! Received on Sun Dec 29 2002 - 05:37:21 CET