Consider a database system for a basketball federation such as the Basketball Federation. The data requirements are summarized as follows: The personnel involved in the league include players, coaches, managers, and referees. Each is identified by a unique personnel id. They are also described by their first and last names along with the date and place of birth. Players are further described by other attributes such as their height and position. Within the players group is a subset of players called national players. National players have an EBA (earned basket average in their professional careers) associated with them. Teams are uniquely identified by their names. Teams are also described by the city in which they are located and the division and league in which they play (such as Super League and League 1). Teams have one manager, several coaches, and several players. Games are played between two teams with one designated as the home team and the other the visiting team on a particular date. The score and game statistics (assists, turnovers, three-point shots, two-point shots, one-point shots, team fouls, etc. are recorded for each team. The team with a greater number of the score is declared the winner of the game. With each finished game, the number of baskets (singles, doubles, triples) obtained by each player is also recorded. With each finished game, the most valuable players (MVPs) are recorded. For simplicity, you can think of MVP of the game as the top scorer player.

Follow the below steps to prepare your project: 1. Design a conceptual EER diagram for a basketball federation using any tool that you want. 2. Generate a physical model. There must be at least nine entity types and required relationships. 3. Use SQL Server Management Studio to show the generated diagram.