Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    16

    Database design issue

    I have been given a senario on a swimming meet. The scenarion is:

    You'll have one or more meets, each of which will have a given place and time associated with it.

    A meet will have one or more events (e.g., 50 m freestyle, 4x100 freestyle relay, etc.).

    An event will have one or more heats.

    A heat will have zero or more individuals entered.

    Each individual will have a time associated with their heat.

    You'll have rules to design how to seed people and determine winners (usually "fastest is best").

    Somehow i have to turn this into a database but i have no idea where to start. This is for a java program and i have some sql knowledge but i really am no good at designing the database so that everything links with each other through the appropiate primary keys etc.
    Any help would be great

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    there are three scenarios for how you ended up being given your scenario

    either your brother-in-law is the general manager of the swimming association and he promised his wife he'd let her brother build the web site

    or you've just been promoted from the print room to the web development team at your company, and they're giving you your first database project to see how you do and what you know

    or this is a homework assignment and you're looking for help in getting started, and maybe some guidance to help you get a good mark

    which of the above scenarios is it, and make sure you answer honestly, okay?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2008
    Posts
    16
    Close. I am actually a student studying java, and this girl i fancy has asked me to help her with her java coursework, but it also involves JDBC which i have not studied yet. I have done some basic sql but never had to design the database. As i say, i am a java student not db student. Who knows, if you give me some advise, you could be participating in the start of a beautiful relationship (with the girl, not you, lol) and helping a fellow bloke get laid.

  4. #4
    Join Date
    Aug 2008
    Posts
    16
    This is what i have done, dont know if it is ok though
    Meet(meetID, place, time)
    Event(eventID, meetID, description)
    Heat(heatID, eventID, description, when)
    Individual(individualID, name)
    HeatIndividual(heatID, individualID, score)

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    that's an excellent start

    give that to her, and good luck
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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