A
Alexandros89 via AccessMonster.com
hi,
i need to create a database to hold data about leagues and teams, keep league
standings for each league and team statistics. i also need to set prices on
each game available for betting. customers should be able to bet on available
games.
i have the following tables:
Customers: CustomerID , Name,Surname,DOB,email, telephone number, password,
address and picture
Teams: TeamCode, Name,Country,City,Stadium,Logo
Leagus: LeagueCode, nf teams, Country/region
Games: GameID, Date,Time, HomeWinPrice,AwayWinPrice,DrawPrice,HomeGoals,
AwayGoals,REsult
Game_teams:GameId,TEamcode,Home/Away,GoalsFor,GoalsAgainst,REsult
Bets:BetID,DAte,Time,customerID,BetAmount,Tax,WinningAmount,Won,claimed
Bet_details:betID,GameId,Option,PriceForOption,result
relationships are all one to many :
customer to bets
bets to bet_details
games to Bet_details
Games to Game_Teams
Leagues to games
Teams to Game_teams
this is what i came up with. i need help creating the necessary forms for
bets and reports for league standings.
any help would be greatly appreciated, if u think i need to add something or
change any relationships feel free to say it.
thanks for your time
i need to create a database to hold data about leagues and teams, keep league
standings for each league and team statistics. i also need to set prices on
each game available for betting. customers should be able to bet on available
games.
i have the following tables:
Customers: CustomerID , Name,Surname,DOB,email, telephone number, password,
address and picture
Teams: TeamCode, Name,Country,City,Stadium,Logo
Leagus: LeagueCode, nf teams, Country/region
Games: GameID, Date,Time, HomeWinPrice,AwayWinPrice,DrawPrice,HomeGoals,
AwayGoals,REsult
Game_teams:GameId,TEamcode,Home/Away,GoalsFor,GoalsAgainst,REsult
Bets:BetID,DAte,Time,customerID,BetAmount,Tax,WinningAmount,Won,claimed
Bet_details:betID,GameId,Option,PriceForOption,result
relationships are all one to many :
customer to bets
bets to bet_details
games to Bet_details
Games to Game_Teams
Leagues to games
Teams to Game_teams
this is what i came up with. i need help creating the necessary forms for
bets and reports for league standings.
any help would be greatly appreciated, if u think i need to add something or
change any relationships feel free to say it.
thanks for your time