CSCI235 Assignment 1

The task of this assignment covers the conceptual model design and implementation of the model into relational schema.

The assignment is given such scenario: you are going to implement a website to provide soccer fans with information about events in a soccer league. In this system, there is a database that contains information about teams, players, game played, results, fixtures, etc.

This soccer league consists of a number of teams - each team has at most 30 players registered. Team is described by a unique name, location (city, town, village) and address of home ground. Each team has one coach and two coach assistants and a number of support staff. Their full names, DOB and hired date are registered.

A player is described by a full name, DOB, weight, height, number and position he usually plays at, all teams he played in the past, transferred dates and transfer fees.

Game are played every weekend. A game is identified by a date, kickoff time and address of a ground when it is played. A game involves two teams, a referee, two linesmen, and technical referee. All events that happen during a game together with time when they happened must be recorded in the database. A set of events includes changes of players during the game, goals scored, yellow and red cards.

.

.

.

All games played have a number of spectators recorded.

Task1: Analyze a domain given above and identify classes, their attributes, associations with other classes, and other elements of conceptual schema, including generalization hierarchies (if any). Draw a class diagram for the above domain.

This is the sample of how it will look like:

Task2: Translate the conceptual schema obtained in the previous step into a relational schema.

This is the sample of translation of conceptual schema into a relational schema -

Task3: Prepare a class diagram from the instance diagram below and explain your multiplicity decisions. Each point has an x coordinate and an y coordinate. Which is the smallest number of points required to construct a polygon? Does it make a difference whether or not a given point may be shared between several polygons? How can you express the fact that points are in a sequence?

(Note: The instance diagram of the polygon shown above happens to be a square.)

The smallest number of points required to construct a polygon is "3". By sharing the points between polygons, the number of objects will be reduced. The points in any polygon are in a sequence.