Data Management and Information Systems Assignment 1: ER Modeling and Relational Model Question 1 A soccer game database keeps track of the world cup championships. Suppose that, after the requirements collection and analysis phase, the database designers stated the following description of the game to be represented in the database: Each team represents a unique country. For convenience, countries are also identified by their codes (like GER for Germany, FRA for France,). Each team consists of players. Each player plays for exactly one team. For each player, we store his name, birth date, number, the role (e.g., goalkeeper), and the games he played in. We assume that each player has exactly one role. Any player is identified in his team by his number. Any game is played by two teams and identified by the game number. For each game, we store its type (e.g., semifinal), the city it was played in, the date, and the result. For every goal, we store the game number, the time it was scored (measured in minutes and seconds since the beginning of the game, e.g., 12:39), the player who scored the goal, all players who assisted and circumstances (e.g., powerplay). For simplicity, we assume that any goal is scored by exactly one player and assisted by any number of players (including 0). For each assistance, we keep its type (e.g., first or second assistance). Since it is unlikely that two goals happen at the same time in the same game, we can identify each goal by its time and game. Draw an E-R diagram that captures this information by following the steps below: 1. Identify the entity sets and the relationship sets. 2. Show any composite attribute and/or weak entity sets. 3. Identify the primary keys/discriminators of entity sets. 4. Determine the cardinality constraints and participation constraints.