CSIT115 Data Management and Security

The high school volleyball games are starting soon, and you are tasked to design a database that contains information about the volleyball teams, volleyball players, coaches, and games played by the teams. A volleyball team is described by a team name, the name of school, and its address. An address consists of street name, a number, and a postal code. There are no two schools having the same name, and the team’s name is unique. A full name, date of birth, height, and weight describe a player. Players have the player numbers, which are unique within a team. The players are also described by the total number of games played, and specialization (such as setters, middle hitters, etc.). Some players may have two specializations (e.g. the player can be specialize in setters as well as middle hitters). A player belongs to a team. The database should contain information when a player joined a team and for how long. The teams play the games. A game involves two teams: home team and away team. A game is described by a date and the school where it has been played, and which team win the game. A date and the school uniquely identify a game. A team plays at least one game as a home team, and at least one game as an away team. Coaches take care of the teams. A coach is described by full name and end of contract date. A coach is identified by a full name. Some coaches belong to a company, and they are further described by the company name, and a monthly pay. Some coaches are freelancer, and they have an hourly wage. A coach is only able to coach one team, and a team can only afford to have one coach. Sometimes, as the coach have ended his/her contract and before a new coach join, the team may have no coach. Draw a conceptual schema for the specification of a database domain listed above. Use a notation of UML simplified class diagrams explained to you during the lecture classes in the subject. There is NO NEED to provide a detailed analysis how a conceptual schema has been created. The final conceptual schema expressed in a notation of UML simplified classes is completely sufficient.