The PR professional soccer league has decided to computerize its facilities by creating a database to store the information of the games played in the league. First of all, we want to store the players' data. For each player you want to store the name, date of birth and position in which he plays (goalkeeper, defender, midfielder...). Each player has a player code that uniquely identifies him. For each of the teams in the league it is necessary to record the name of the team, the name of the stadium in which it plays, the capacity (maximum number of people allowed in the stadium where a soccer match is played), the year of foundation of the team and the city where the team is from. Each team also has a code that uniquely identifies it. A player can only belong to one team. For each game played by the teams in the league, the date of the game, the goals scored by the home team and the goals scored by the away team must be recorded. Each match will have a numerical code to identify the match. You also want to keep a tally of the goals in each match. You want to store the minute 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, we want to store, in the database, the data of the presidents of the soccer teams (id, name, surname, date of birth, team of which he is president and year in which he was elected president). A soccer team can only have one president, and a person can only be president of one team in the league. Pass the resulting entity-relationship model to the relational model.

With the above information DESIGN a solution for the company that contains the following:

E-R Model. Create and popularize the DB with at least 10 tuples per entity; Hashing techniques must be included in the creation process.

Answer rating: 100% (QA)

The ERD possesses 5 entities The relationship comprise has score in play T... View the full answer