N
N
Nur-Magomed2015-10-22 22:25:13
Database
Nur-Magomed, 2015-10-22 22:25:13

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.
a96b096788dc4ef893fdd34c16ec2131.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2015-10-22
@Rsa97

Is it correct that replaces.team_id refers to teamplayers?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question