Again, please forgive my total ignorance.
My ERD shows that the web links (URL table) are connected, via the
sub-categories (SubCat table),
to the main categories (Categories table). Is this correct for what I
am trying to achieve ?
Or should I also link the URL table to the Categories table ?
Have been trying to create the ER Diagram with "MySQL Workbench",
and getting very frustrated.
So far I have this .... www.ProBowlUK.co.uk/files/ERD_00.pdf
----- Original Message -----
From: Martin Gainty
To: bobsharp@stripped ; mysql@stripped
Sent: Friday, September 04, 2009 6:09 PM
Subject: RE: Database design - help
> given the following table layouts
> URLs:> URL_ID (primary key for URL)> URL_TEXT>> URL_CATEGORY> URL_ID
> (key which points to URL.URL_ID)> CATEGORY_ID (key which points to
> CATEGORY.CATEGORY_ID)> SUBCATEGORY_ID> PK: (URL_ID, CATEGORY_ID)>
> CATEGORY> CATEGORY_ID (primary Key for Category)> CATEGORY_TEXT>>
> SUBCAT_ID (concatenated key for SubCat)> CATEGORY_ID (concatenated key
> for Subcat)> SUBCAT_TEXT>so the diagram would look something like like
> URL_CATEGORY Table (URL Table) (CATEGORY TABLE)
> URL_ID 1--------->1 URL.URL_ID
> CATEGORY.CATEGORY_ID1<---1CATEGORY_ID URL_TEXT
> 1 ↓
this is labour-intensive work that every DBA must perform to create a
> From: bobsharp@stripped
> To: mysql@stripped
> CC: john.l.meyer@stripped
> Subject: Re: Database design - help
> Date: Fri, 4 Sep 2009 16:24:22 +0100
> Thanks for all the responses. However I am still stuck for a MySQL db I
> can create
> and code in PHP. Attached is a brief example of data to be used.
> One problem I have is with providing a listing that includes ...
> WTBC (Category without SubCats) and the 3 Zones (also, Cats without
> SubCats ??? )
> (This is for a complete WTBC listing, in practice it may list depending
> selected Zone)
> The example Schema is interesting, but is there another way of storing
> in one table and join them to Category and SubCat tables ?
> An example of the ER Diagram would also be helpful to me.
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 13901 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
The Professional version does not have this message
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.77/2346 - Release Date: 09/04/09