A national soccer league has decided to create a database to save the information of the games/matches that are played in the league. First they want to save the player's information. From each player it is required to get the name, date of birth and their position. Each player has an ID number that identifies them uniquely. From each team it is required to register its name, stadium, stadium capacity (number of people allowed in a stadium), year founded and its city. Also each team has a unique ID number that identifies them. A player can only belong to only one team. For each game/match that is played in the league we must register the date it was played, the home team goals and the visiting team goals. Each game/match will have a unique ID number that will identify it. Also it is required to have a count of the goals that happen on each game/match. It is required to save the minute a goal was scored and its description. A game/match has several goals and a player can score several goals in the same game/match. Finally it is required to store, in the database, the soccer team president's information: ID, name, last name, date of birth, team of which they are president and the year they were elected. A soccer team can only have one president and a person can only be president of one soccer team of the league.

a. Users that intervene in the system (roles) with their description

b. Use Case Statement -"visual paradigm"-

c. Use Case Diagrams

d. User Stories

e. Entity-Relation model

f. Create the database and populate it with at least 5 tuples per entity