A soccer game database keeps track of the world cup championships. Suppose that, after the requirements...

 

Transcribed Image Text:

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. 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 [20 marks] [10 marks] [5 marks] [15 marks] 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. 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 [20 marks] [10 marks] [5 marks] [15 marks]

Answer rating: 100% (QA)

Step 1 Definition EntityRelationship ER Diagram is a graphical representation used in database desig... View the full answer