Gossamer Forum
Home : Products : DBMan SQL : Discussion :

database design problem

Quote Reply
database design problem
I want to desig a website about soccer betting useing DBMAN sql.some tables in the DB like this:

League: LeagueID, LeagueName
Team: TeamID, TeamName, LeagueID
Game: GameID, Date, ????
...................
..................

Game is where my problem lies. I want the Game data to list the date,
score, and which team plays. But that means I have to access the Team table
twice within the same record for Game. What is a better way to handle
this?and how add the data to Database using DBMAN sql easily?

Last edited by:

redstar: Oct 22, 2003, 8:53 PM
Quote Reply
Re: [redstar] database design problem In reply to
I think that is the only way. I.e:

Game (GameID, GameDate, TeamID_A, TeamID_B, Goals,...)

Hope that helps.

TheStone.

B.
Quote Reply
Re: [TheStone] database design problem In reply to
thanks for your reply! but i still hava a question,my database :

League: LeagueID, LeagueName
Team: TeamID, TeamName, LeagueID
Game: GameID, GameDate, TeamID_A, TeamID_B, Goals
Odds: OID,Home,Draw,Away,GameID,CID
BettingCompany:CID,CName

I use DBMAN SQL 2.1 ,when I add data of Odds, How can I have two input menu(input name TeamID_A,input name TeamID_B) automatically generated from table Game.Like:Liverpool v Leeds so what shall I do?thks!