List:General Discussion« Previous MessageNext Message »
From:BobSharp Date:September 5 2009 7:48am
Subject:Re: Database design - help
View as plain text  
Thanks

Not sure how I'm reading this,   but shouldn't the URL be linked to SubCategory ? 


  ----- Original Message ----- 
  From: Martin Gainty 
  To: bobsharp@stripped ; mysql@stripped 
  Cc: john.l.meyer@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> 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@stripped>
  > 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. Find out more. 


------------------------------------------------------------------------------



  No virus found in this incoming message.
  Checked by AVG - www.avg.com 
  Version: 8.5.409 / Virus Database: 270.13.76/2344 - Release Date: 09/03/09 18:05: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

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