List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:September 4 2009 5:09pm
Subject:RE: Database design - help
View as plain text  
> 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 
______________________________________________ 
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
 
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.




> 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
> 
> 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
> 
> 
> 
> 
> 
> ----- Original Message ----- 
> From: "John Meyer" <john.l.meyer@stripped>
> To: "BobSharp" <bobsharp@ntlworld.com>
> Cc: <mysql@stripped>
> Sent: Monday, August 31, 2009 4:56 PM
> Subject: Re: Database design - help
> 
> 
> > BobSharp wrote:
> >> As a complete newbie in MySQL,  I need a database
> >> to store URLs related to Tenpin Bowling.
> >>
> >> There are several Categories ...  Equipment Manufacturers,
> >> Organistations, (UK) ProShops, (UK) Bowling Centres, Personal
> >> Websites, Misc., Coaching & Instructional websites, etc.
> >>
> >> There will be some sub-categories.
> >> eg:  Organistions will have ... Zones of WTBC,  National Organisations
> >> within
> >> the Zones, UK organisations,  Disabled Bowling organisations, ...
> >> eg:  Personal Website might have ... Bowler's,  Pro Bowler's, Leagues,
> >> etc.
> >>
> >> Can anyone suggest how I should set out tables for this database ?
> >
> >
> > Here's one suggestion
> >
> > Table:
> >
> > URLs:
> > URL_ID
> > URL_TEXT
> >
> > CATEGORY
> > CATEGORY_ID
> > CATEGORY_TEXT
> >
> > SUBCAT
> > SUBCAT_ID
> > CATEGORY_ID
> > SUBCAT_TEXT
> >
> > URL_CATEGORY
> > URL_ID
> > CATEGORY_ID
> > SUBCATEGORY_ID
> > PK: (URL_ID, CATEGORY_ID)
> 
> 
> --------------------------------------------------------------------------------
> 
> 
> 
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.409 / Virus Database: 270.13.72/2337 - Release Date: 08/31/09 
> 05:50:00
> 
> 
> -- 
> 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
> 

_________________________________________________________________
Windows Live: Keep your friends up to date with what you do online.
http://windowslive.com/Campaign/SocialNetworking?ocid=PID23285::T:WLMTAGL:ON:WL:en-US:SI_SB_online:082009
Thread
Downloading old version of MySQL ?David Harrison30 Aug
  • Re: Downloading old version of MySQL ?Joerg Bruehe31 Aug
  • Database design - help BobSharp31 Aug
    • Re: Database design - helpJohn Meyer31 Aug
  • Re: Database design - helpBobSharp4 Sep
    • RE: Database design - helpMartin Gainty4 Sep
  • Re: Database design - helpBobSharp5 Sep
  • Re: Database design - helpBobSharp5 Sep
Re: Database design - helpBobSharp6 Sep