DB Design

 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me



Go Back   Tutorialized ForumsDatabasesDB Design

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Tutorialized Forums Sponsor:
  #1  
Old October 20th, 2004, 04:56 PM
kaldorn kaldorn is offline
Contributing User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Posts: 1 kaldorn New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: < 1 sec
Reputation Power: 0
Soccer database

I'm currently working on my club website and I want to make a database for storing matchresults, teams, players etc. and an updated league table. The league table should be updated automatically when a match is registered. I have been working on a database but I cant figure out an effective way to register and showing information. The problem is the match table and the update of the league table. I would greatly appreciate any help.

I want to store the following information:
Season
Matches
MatchType
MatchPlace
Opponent
Goals
Yellow / Red Cards
Substitutions
Injuries
MatchComment
Referee
Players
Playerspositions
Teams (Men, women etc.)

It is possible that I have forgotten som elements that should be a part of the database. Feel free to add fields or tables.

Thanks in advance
__________________
Wise men don't need advice. Fools wont take it.

Reply With Quote
  #2  
Old November 8th, 2004, 04:29 PM
MNSelect MNSelect is offline
Contributing User
Tutorialized Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Posts: 2 MNSelect New User: is a brand new recruit and a unknown entity at this point. 
Time spent in forums: < 1 sec
Reputation Power: 0
Kaldorn, I may be missing something but what I don't see is a matchID column. Your database table for the matches has to have a primary key / unique identifier. As the information (shown below) is entered and submitted from a form, the database will automatically create the next matchID number. You can then display the info for any given match by a number of methods, Date, Location, Team Name ...
Does that help?

Reply With Quote
Reply

Viewing: Tutorialized ForumsDatabasesDB Design > Soccer database


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 

Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap