Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009

    Soccerchampionship database

    Hey folks, I'm new and I need some feedback and ideas on my work.
    Well I am making a soccerchampionship program with database funtionality, and I'm making this one in Acces. My question is what entities, attributes can I use per table. I have now the tables:
    Groups(ea. Netherlands is in group A),
    I need to link these things together, because a group has a championship, and a championship has groups. (countries have group, group have countries).

    So I would like to hear your feedback and suggestions.
    Thanks, Jeroen

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    suggestion: do some research on foreign keys

    that is how you link them together | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2004
    out on a limb
    I think you have the basis of an interesting model there Jeroen, but I'm a little concerned by the language you are using there. groups don't have a championship, rahter a championship is comprised of several groups. ie the championship is the parent entity , the groups are the tables that comprise the various qualification stages out of which the eventual winner appears

    the relationship should reflect the order of precedence

    lets say you are modelling UEFA or FIFA
    they hold championships, in which registered national sides compete for various events
    so an organising authority has member events (so the precedence is an organising authority entity, that is referred to in the events entity)
    a nation is affiliated to one or more organising authorities (eg FIFA, UEFA)
    a championship os made up of various matches between specific teams (nations).

    so there should be a row in, say, your championship table which is referred to from other rows identfying the countries playing in that championship.

    however depending on what you are trying to model ther is another layer of complexity. is your model tryng to refelct a single championship say Euro 2010? ir is it trying to reflect every Euro Championship, and optionally every FIFA world cup....

    the reason why I ask is that this changes the model significantly, because you have to account for not just each team each match, each table but qualify that for each and every year.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts