Results 1 to 14 of 14
  1. #1
    Join Date
    Aug 2006
    Posts
    6

    Help with table stuctur and design

    Team,
    I am trying to create a fantasy football website.
    My project page is listed hear:
    http://www.theufl.com/ufl_project.htm
    Tools I am using are:
    I am using phpmyadmin and php of course with dreamweaver.

    My first dillemma is what tables to create.
    I know i need a players table, owners table, transactions table(for trading adding,dropping and trading players), but I do not know what else I need.
    I also want to emulate a page a www.espn.com
    http://sports.espn.go.com/nfl/player...e?statsId=4256
    The players page. However I am confused on how to start my tables.
    I want to do the grunt of the work first obviously with the players table,
    which will be the primary goal of this project.
    The question I have immediately towards this table is do i include the stats and the player bio stats all in the same table, or do i break them up I will have a players page or year page in stats to view the players name by name and team by team. How do you suggest I do this.
    Also, if you could elaborate also on what tables and fields I would need for this database would be so appreciated.

    you can email me directly at:
    karljames@tampabay.rr.com
    I am also on aim kjames1973.

    thanks,
    karl

  2. #2
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Look at the page and think about one to many relationships. What information is there one instance of and what information are there many instances of that you can see?

    I suggest you do the first draft of the datamodel yourself. Then come back and ask for feedback. We're not here to do your homework.

  3. #3
    Join Date
    Aug 2006
    Posts
    6
    Certus,
    I wasn't asking for you to do my homework for me.
    I am simply asking advise.
    I am sorry if I am not a senior in database making.
    I wish I was so I wouldnt have to ask these kinds of questions
    but I am trying to learn, surely you were in my position at one
    time when you didnt know what a database was.

    I am sorry if I come across needy, but I really do need the help.
    I am just frustrated. I am reading all I can read but with out further
    explanation its hard sometimes,and I also am sorry I do not know how
    to ask the right questions if I am confusing.

    I have created the players table already in my db.
    However I am not sure if I should keep the players bio and players stats
    all in the same place.

    thanks, Karl
    Last edited by karljames; 08-14-06 at 03:04.

  4. #4
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Do a screen capture of your players table. Post it as an attached image.

    We'll take it from there.

  5. #5
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255
    Quote Originally Posted by karljames
    I am reading all I can read but with out further
    explanation its hard sometimes
    Name the books you have read on the subject. Then show us the work you have done and ask specific questions.
    and I also am sorry I do not know how to ask the right questions if I am confusing.
    Don't worry about 'how', just ask it.
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

  6. #6
    Join Date
    Aug 2006
    Posts
    6
    Well,
    I think I did ask. How do i set up this players table if i want to copy the table that espn.com has. DId they throw all Bio stats and players into one table in the database or are they seperate.
    The link again was.http://sports.espn.go.com/nfl/player...e?statsId=4256

  7. #7
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    espn probably treats it as a data warehouse for rapid retrieval. But I am not going to go into that.

    Again. Look at what data on the page has only one instance. That is your first table. Then look at data groups of which there are many instances. These are your child tables.

  8. #8
    Join Date
    Aug 2006
    Posts
    6
    Well,
    You are probably right on that.
    Its a way for them to save money I a sure.
    How can I send you a screen shot of what i have so far.
    I have not finished this table but at least I can show
    you what I have going for you, to show you where I am at for
    this particular table.
    I am using phpmyadmin to enter in table info.

  9. #9
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    shift-PrtSc

    open MS paint

    Cntrl-V

    Save as jpeg.

    Attach to your next post using manage attachements.

  10. #10
    Join Date
    Aug 2006
    Posts
    6
    Certus,
    I could not find paint on my pc.
    However, I pasted this in word.
    Let me know if you do not have word.
    If you have it can we please try to go
    into more detail on how i should start these
    tables i need for this project.
    Your help would be greatly appreciated.
    I basically need a template. Is that so
    wrong to ask for?

    Thanks for any more info and your help buddy!
    Karl
    Attached Files Attached Files

  11. #11
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    judging by that screenshot you are on Windows XP, so go Start > Programs > Accessibility and vwalah, there it is, Paint

    first point -- don't use spaces in a column name

    next, split off those columns which pertain to a player's current team (e.g. Position, Number) into a PlayerTeam table

    see Introduction to Data Modeling

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  12. #12
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by r937
    blah blah blah vwalah blah blah
    Gosh - I didn't know you could speak French.

    Nice Data Modelling link too
    Testimonial:
    pootle flump
    ur codings are working excelent.

  13. #13
    Join Date
    Aug 2006
    Posts
    6
    What are you trying to say pootle flump.
    Are you referring to me or r937?

    Karl

  14. #14
    Join Date
    Dec 2003
    Location
    Canada
    Posts
    710
    Looking at that screen shot you should separate team from player. You should also note that you have several aggregate values that should be handled as nonaggregates in separate tables.

Posting Permissions

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