Skip to content

HW1: Soccer League

Due: Monday, Jan 29th

United Soccer League logo
Image source: Wikimedia Commons

Objectives

  • Use data conceptual modeling techniques to create an EER model.
  • Collaborate with other students using draw.io (app.diagrams.net).

Chen Notation

For this assignment, you must use Chen notation to draw the diagram. Here is a nice summary of Chen notation on the Vertabelo blog. SoftwareIdeas.net also has a summary of Chen notation. Note that we are not using either of these software tools, but the summaries are helpful.

Getting Started

This assignment must be completed in groups of 3–4 students.

After deciding who will be in your group, one student should do the following:

  • Go to draw.io and click the blue Start button.
  • Click the Google Drive button and authorize the app on Google Drive (if needed).
  • Click the Create New Diagram button and select Blank Diagram as the template.
  • Give the file a meaningful name like CS 374 HW1 Soccer.drawio (or similar name).
  • Click the orange Share button (top right) and add the other group members.

Once the diagram is created and shared, all group members will be able to edit simultaneously.

Data Requirements

You are creating an enhanced ER model for a soccer league:

  • The people involved in the league are players, coaches, managers and referees. Each one has a unique personnel ID. Their first and last name, date of birth, nationality and phone number(s) are also important.

  • Players have some other information: their height, weight, the position they usually play, and whether they are right or left-footed.

  • Team names are unique within the league. A team is also described by the city in which it is located, and the full address of the stadium is also required. (The stadium might not be located exactly in the city the team is associated with.) This soccer league is also broken up into divisions, so a team has a division.

  • A team has a single manager, multiple coaches, and multiple players.

  • Games are played between two teams. One team is the home team, which means the game is played in its stadium, and the other is the visiting team. A game occurs at a specific time on a specific date. The score (number of goals) for each team is associated with the game.

  • For each game, several statistics are collected for each player who plays in the game: minutes played, number of goals scored, number of assists, number of fouls committed, number of yellow cards, and number of red cards.

  • Goal keepers have some extra game statistics: goals scored against the goalie, shots taken against the goalie. A goal keeper has a game save percentage and overall save percentage – how many of the shots taken against this goal keeper do not result in a goal.

  • A game is officiated by at least one referee. The number of red and yellow cards given by a referee per game is tracked.

You may ask for clarifications about these requirements from your instructor. You should record any additional information you get from these clarifications, along with any assumptions you made in the supplementary notes for your model.

Submission

Submit a 2-page pdf document for your group to Gradescope that includes:

  • Page 1
    • The names of all the group members. Please also add group members to your submission (when uploading).
    • An image of your EER diagram (not hand-drawn) that follows the Chen style.
  • Page 2
    • No more than one page of supplemental notes for your model, including:
    • Definitions of terms or abbreviations that you used that were not given in the requirements.
    • Any assumptions that you made about information that was not included in the requirements.
    • Any extra data items you created that were not mentioned in the requirements.

Acknowledgements

This assignment was adapted from a similar assignment about a baseball league in the book Fundamentals of Database Systems by Elmasri & Navathe. Detailed information about soccer statistics came from https://fbref.com/.