Answer the question
In order to leave comments, you need to log in
How to properly build the database structure of sports clubs?
Given (assignment for educational purposes):
“Database of football matches”. The following are subject to accounting: a sports club, team players (full name), date of the match, playing teams, goals scored, authors of goals.
Note: The database is for the major league of Russia. Assume that one club = one team. It is necessary to take into account the replacement of players during the match.
Sketched the following structure. Can you please tell me if this structure is correct? Does anything need to be added/removed?
PS goals.self - tells who the player scored: the opponent or his own team (own goal).
It is already known that the team1_score and team2_score fields (from the matches table) in such a structure will need to be updated simultaneously with the goals records.
The sportclubs table has been omitted as 1 club = 1 team.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question