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
Subject Author Views Date
Thread database design problem redstar 3013 Oct 22, 2003, 8:12 PM
Thread Re: [redstar] database design problem
604 2904 Oct 23, 2003, 11:04 AM
Post Re: [TheStone] database design problem
redstar 2893 Oct 23, 2003, 6:04 PM