Conceptual database schema [closed]

Navigation
1

My problem is this: I am designing a BD for an application that manages the soccer tournaments of an institution The problem is that I must comply with the following:

Match results record

  • You must allow the administrator to indicate which students played in that game

  • Players who have a red card must not appear in the Previous list to make the filter of those who played

  • You must register the place of play (axis multipurpose room)

  • You must record the following information for each team:

    • The number of yellow cards and to whom they belong
    • The number of red cards and who they belong to
    • The number of goals and who they belong to
    • The teachers who were in charge of the game (Two, there are always two)
    • The main referee
    • The assistant referee

    • The time and date will already have been specified

    Leaderboard

    With the following elements:

    • Team number
    • Team name
    • Points
    • PJ (Matches Played)
    • PG (Won Parties)
    • PE (Matched Matches)
    • PP (Lost Parties)
    • GF (Goals to Favor)
    • GC (Goals Against)
    • DF (Difference of Goals)
    • Top scorer.

    Player's history

    The application must show a history of the player who has the following information:

  • It must show all the yellow cards that player has had in the whole tournament until the date the history is shown and in which match he had the cards
    • Number of yellow cards
    • Date
    • Versus (Example 1ACA vr 2ACA)
  • It must show all the red cards that player has had throughout the tournament until the date the history is shown and in which match he had the cards
    • Date
    • Versus
  • Must show all administrative punishments that player has had throughout the tournament until the date the history is shown
    • Start date
    • Final Date
    • Reason for the sanction
  • The goals that player has made to date to show the history with the following data:
    • N. Goals
    • Date
    • Team I was with when I scored the goal
    • Team who did it

    • And currently I have the ER diagram

    I do not know how to save the winner of the game and the relationships that are involved with the party entity do not know if they are well. Also you must save the information for years or that all information about what happened in the tournament this year for example must be available within 5 years that is why all entities are related to the entity tournament

    If someone can help me and correct it, I would greatly appreciate it. Thank you in advance

        
    asked by Gerardo Sorto 25.12.2018 в 22:22
    source

    0 answers

    Compare that a dates in timestamptz format, PostgreSQL, Sequelize problem in achieving an effect with javascript html and css