Results 1 to 3 of 3
  1. #1
    Join Date
    May 2014
    Posts
    2

    Simple Database for Soccer Championship

    Title says it all.

    I wanted to know if this non-normalized to normalized structure is done right.
    Some clarifications:
    A game's location is related to a team's stadium.

    The composed key for fixtures and games is done so that it will create a 1_2 ID(Competition_Fixture) relationship with the ID of the Games. At least that is what I tried to do.

    ________________________

    Non-Normalized Structure

    Competition
    id Competition
    nameCompetition
    Year
    Fixtures*
    id Fixtures
    name Fixtures
    Games*
    idGame
    nameGame
    Local
    Date
    Time
    Teams*
    idTeam
    nameTeam
    Stadium
    Players*
    idPlayer
    namePlayer
    nJersey
    Position




    1 FN

    idCompetition
    nameCompetition
    Year

    idFixture
    idCompetition
    nameFixture

    idGame
    nameGame
    Local
    Date
    Time
    idFixture

    idTeam
    nameTeam
    Stadium
    idGame

    idPlayer
    namePlayer
    nJersey
    Position
    idTeam


    2 FN

    idCompetition
    nameCompetition
    Year

    idFixture
    idCompetition
    nameFixture

    idFixture
    idCompetition
    idCompetition

    idGame
    nameGame
    Local
    Date
    Time
    idFixture

    idTeam
    idGame

    idTeam
    nameTeam
    Stadium

    idPlayer
    idTeam
    nCamisola

    idPlayer
    namePlayer
    nJersey
    Position


    ________________________


    Thank you in advanced guys

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    This has the strong whiff of homework.
    what area(s) do you have a problem with
    what do uou expect of the contributors on here

    bearing in mind we dont do other peoples homework. We dont act as virtual markers of your assessments.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2014
    Posts
    2
    I just want to know if this is right considering the clarifications I made for 2 doubts that would occur. And if not, why? I'm trying to figure this out. Not very good at normalizing.

Posting Permissions

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