Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2015
    Posts
    2

    Help with soccer Database normalization

    Hi,

    New to the forum and database design. I've played around with databases before but nothing too serious. I'm watching some database for beginners lessons on youtube to try and get some knowledge.

    Database Background

    I'm looking to create a database that will hold soccer teams, competition, fixtures, results, half time score, full time score. The teams will be from all over the world, the competitions will be domestic and cross border (Champions League, Europa League).

    Information that I'm looking to get out of the database

    -Goals Per Game
    -Goals Per Team
    -Goals per Competition
    -Games where both teams scored, per competition, team

    I have a spreadsheet with data with the following headings

    Country
    Competition
    Round
    Season
    Date
    Home Team
    Away Team
    Home Half Time Score
    Home Full Time Score
    Away Half Time Score
    Away Full Time Score
    Results

    I have taken these headings and created the following tables:

    tblMatch
    matchID - PK
    matchDate
    matchTime
    seasonID - FK - tblSeason
    competitionID - FK - tblcompetition
    roundID - FK - tblRound


    tblHomeTeam
    matchID - FK - tblMatch
    teamID - FK - tblTeam
    HomeTeamHaflTimeScore
    HomeTeamFulllTimeScore


    tblAwayTeam
    matchID - FK - tblMatch
    teamID - FK - tblTeam
    awayTeamHaflTimeScore
    awayTeamFulllTimeScore


    tblTeam
    teamID - PK
    teamName
    teamNickName

    tblSeason
    seasonID - PK
    seasonDesc
    startDate
    endDate

    tblCompetition
    competitionID - PK
    competitionName
    countryID - FK - tblCountry

    tblRound
    roundID - PK
    roundName

    tblCountry
    countryID - PK
    countryName

    Looking for any comments on my normilization and if you think i've got it right. My main concerns are around the match and home and away teams. I've removed result as I think i can find that out via calculation of scores.

    t
    Last edited by delboy2405; 12-05-15 at 17:59.

  2. #2
    Join Date
    Nov 2015
    Posts
    2
    ER Diagram attached

    Click image for larger version. 

Name:	soccerdatabase.png 
Views:	8 
Size:	47.4 KB 
ID:	16659

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •