need help on project for football scores and bets

  • Thread starter Alexandros89 via AccessMonster.com
  • Start date
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, no_Of 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top