Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011

    Unanswered: Feedback on design


    I am in the process of creating a sporting schedule schema.
    Here is what I have so far -

    schedule (schedId(pk), hometeamid(fk), awayteamid(fk), date, start, end, location, ....)
    teams (teamid(pk), teamname, leagueid(fk), ....)
    league (leagueid(pk), sportid(fk), ....)
    sports (sportsid(pk), name, ....)

    Any thoughts on this design?

    Thanks in advance.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    what does the assignment call for?

    can you explain your design choices (to yourself), and justify why you came to this design?

    ultimately its your design, and if it matches the design brief you have then its plenty good enough. without knowing the purpose / business requirement then its very hard t knwo if this design is good enough or not.

    most sports have a season, or annual copmpetition
    some have additional events during that season. eg football in Europe has national leagues and national cup competitons (England has 4 professional leagues, god knows how many amateur / semi professional leagues. all teams can elect to play in a league structure, all teams can enter the FA cup, all professional league teams can also enter the league cup. teams in the top tier of the professional league also play in pan european competitions.
    hence thats why, without knowing what this model is meant to represent I doubt anybody could give you a yea or nay
    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