QUESTION $1(10$ marks$)$ Read and analyse the following specification of a sample database domain. 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 theteam$$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.