Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2009
    Posts
    2

    Unanswered: please help with a swim club database

    hi everyone this is my first post, and i am the first to admit that i am a complete novice as this isnt a field a specialise in, i would appreciate it if someone could point me in the right direction.

    I am trying to design tables with relationships for an efficient swimming club database. The main aim being a database that uses swimmers "personal best times" to aid a user to enter particular swimmers into there stongest event for the next competition.

    I am really struggling with the table/relationship design, could someone give me a generic example, or ideas of the structure.

    To give you a better idea the sort of queries that i want to run are "what is swimmer X's fastest time for the 50m frontcrawl" as well as "which swimmer has the fastest time for the frontcrawl". E.g. queries from swimmers as well as from specific stokes.

    if someone is willing to help i could put up what i have so far in terms of tables etc

    edit: i dont want anyone to manually record personal best times and input them onto the system, i want the personal best times to be derived from previously entered data

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    hi everyone this is my first post, and i am the first to admit that i am a complete novice as this isnt a field a specialise in, i would appreciate it if someone could point me in the right direction.
    Yellow pages? Sorry! Couldn't resist.

    I am really struggling with the table/relationship design, could someone give me a generic example, or ideas of the structure.
    SWIMMER (details about each swimmer)
    EVENT (details about each event)
    PERFORMANCE (foreign keys for swimmer and event along with [best] time)

    That might give you a start.

    if someone is willing to help i could put up what i have so far in terms of tables etc
    You are asking for help. Can't you assume that someone will and therefore put it up there anyway? This IF gives anyone the option of saying....well I can't help because I can't see the tables!!

    edit: i dont want anyone to manually record personal best times and input them onto the system, i want the personal best times to be derived from previously entered data
    This makes no sense. How can you have previously entered data if you are just creating the tables?? O_o

    One way or another, someone has to manually enter the best times into the system.... right? It makes sense to also be able to edit those best times... surely??
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Feb 2009
    Posts
    2
    Quote Originally Posted by StarTrekker
    Yellow pages? Sorry! Couldn't resist.


    SWIMMER (details about each swimmer)
    EVENT (details about each event)
    PERFORMANCE (foreign keys for swimmer and event along with [best] time)

    That might give you a start.


    You are asking for help. Can't you assume that someone will and therefore put it up there anyway? This IF gives anyone the option of saying....well I can't help because I can't see the tables!!


    This makes no sense. How can you have previously entered data if you are just creating the tables?? O_o

    One way or another, someone has to manually enter the best times into the system.... right? It makes sense to also be able to edit those best times... surely??
    thanks for reply
    with regards to the last part of your post: what i am looking for is for the user to input the swimmers time after they have completed the event. For example a swimmer may get 1min30sec in the 50m frontcrawl one week (this is inputted into the sysytem) but then could get a faster time e.g. 1min25sec the week after(inputted into the system the exact same way as the first time). But with a query i want to be able to look up each age groups best time for a given event.
    Last edited by hrov; 02-03-09 at 13:09.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    presumably an event comprises many races, which swimmers may take part in more than one.

    so you may have the hrov open amatuer competition, wish has 100m, 2044m 400m etc
    presumably you need to qualify what the race actually is (ie 100m), that may also need subqualifying so you know (100m freestyle)
    ytou may need to know whether it was 'the' race or a qualifier

    each swimmer would have an association with each race they are entered in. ( I dunno if you need some form of completion code (ue did not start, retired, injured, finsihed, disqualified etc...) and as part of that assocatiation you woudl have your time.

    having sorted out your data yopu then need to start looking at how you retrieve the various bits and string it all together

    you need a query that finds the position/place where that person finished (could be a tricky one), and you need another query which finds the fastest (read lowest time) per swimmer per type or race.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Feb 2009
    Posts
    1
    If this isn't your area of expertise, why are you going to such trouble to create something from scratch? Can't you use something like Natalog (Natalog Swimming Software) which handles top times?

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Because it has a never-ending cost associated with it? That would be my guess.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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