Football League Database Design Exercises
Translated by
ScribdTranslationsFootball League Database Design Exercises
Translated by
ScribdTranslationsExercises - Data Management II
(Week 01)
In each of the following exercises, you are asked:
First, develop the entity-relationship model,
Then the logical model.
Create the physical model in Oracle
Implementar5 consultas SQLpor cada caso (Sentencia SQL y resultado de la consulta)
CASE 02
The professional football league, presided over by Mr. Ángel María Villar, has decided to computerize its
installations creating a database to store information about the matches being played in the
league.
First, we want to save the data of the players. For each player, we want to save the
name, date of birth and position played (goalkeeper, defender, midfielder...). Each
The player has a player code that uniquely identifies them.
For each of the league teams, it is necessary to register the team name, stadium name in
the one who plays, the capacity it has, the year the team was founded and the city the team is from. Each
team also has a code that uniquely identifies it. A player can only belong to a
unique team.
For each match that the league teams play, the date on which the match is played must be recorded.
the goals scored by the home team and the goals scored by the away team. Each match
it will have a numeric code to identify the match.
It is also desired to keep a count of the goals in each match. The minute is wanted to be stored.
in which the goal is scored and the description of the goal. A match has several goals and a player can score
several goals in a match.
Finally, it is desired to store in the database the data of the presidents of the football teams.
ID number
president). A soccer team can only have one president, and one person can only be
president of a league team.
2
2