From: BobSharp (bobsharpntlworld.com)
Date: Sun Sep 06 2009 - 10:09:47 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

cheers

  ----- Original Message -----
  From: Martin Gainty
  To: bobsharpntlworld.com ; mysqllists.mysql.com
  Cc: john.l.meyergmail.com
  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>
> 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 ↓
                  1
  SUBCAT.CATEGORY_ID
  SUBCAT.SUBCAT_TEXT

  this is labour-intensive work that every DBA must perform to create a
Database
  Martin Gainty
  ______________________________________________

> From: bobsharpntlworld.com
> To: mysqllists.mysql.com
> CC: john.l.meyergmail.com
> Subject: Re: Database design - help
> Date: Fri, 4 Sep 2009 16:24:22 +0100
>
> Hi
>
> 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
on
> selected Zone)
>
>
> The example Schema is interesting, but is there another way of storing
all
> links
> in one table and join them to Category and SubCat tables ?
> An example of the ER Diagram would also be helpful to me.
>
>
> cheers
>
>
>
>

--
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
17:51:00

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]