Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-29 : 23:02:47
|
James writes "Ok, here is a (what I believe to be) a toughie:
Suppose I want to construct a database where basketball teams are able to store each of their respective schedule information. The schedule would contain the following:
GameID
TeamID
Date
Location
Opponent
Home/ Away Game (select one)
Venue
League/ Non-League Game (select one)
Additionally, we want the teams to be able to update the schedule with the game information after it's been played. So there should be another table that contains:
GameID
Winner
My Score
Opponent Score
Overtime
Now, since each team maintains each of their respective schedule, there will be undoubtedly double entries for each games played (one in the home team's schedule and one in the away team's schedule).
The question is, how would you synchronize this information so that one may derive a 'master schedule' of all the games played complete with the following information:
Date
Home Team
Visiting Team
Venue
Winner
Home Team Score
Visiting Team Score
.... etc
This way, one can view all of the games available at a particular date without having to see each respective team schedule.
Your help is most appreciated.
respectfully yours,
James" |
|
|
|
|
|
How to synchronize game schedule for a sport?