Design the basketball league management system.

The requirements for the test project are: You need to create a basketball league management system. The database model should support storing information about the league, teams, player and their contracts and should provide reporting functionality. Each league can have multiple seasons. Each league contains N teams playing in it. Each team can have 15 players on the team. However, it is possible that a league can decide each season what is the maximum number of players. Each player can play on one or multiple positions: point guard, shooting guard, small forward, power forward and a center. Each player has a contract with a team for a specific season. It is possible to have a one-year contract or multi-year contract. Each team can spend a limited budget for his team. It means if a salary budget is $50.000.000, overall contract value should be below that value. Otherwise, a league will detect the limit was breached and a team will have to pay for a luxury tax, which is 100% of an value above the limit. League checks contract budgets. Teams can trade players. It is important to know when teams are doing trades, a sum of player’s contracts on each side must be similar. There can be a difference of 20% of overall traded value. E.g. Player A and B have an annual contract value of $10.000.000 and a team wants to trade them in order to get a player C. His annual contract value is $12.000.000. This is allowed, however, teams must be sure they have enough empty spots on a roster. Players can get injured during a season. In that case, their contract is not calculated in a budget. Also, in that case, an empty spot is available on a team roster. Create an Entity Relationship Model (ERM) diagram, including: a. A description of the entities and their attributes. b. Relationships A database which implements the ERM. SQL script that will create the whole database along with the constraints and relationships. a. Create a function which generates sample data. Create a function which places a player on an injury list. Also, create a function or the same one to remove a player from an injury list. Create a function or a procedure to create a trade between two teams. Allow trading multiple players from each side. Create a function which will provide an information of the most expensive starting lineup for a specific team. A starting lineup has one player on each position and it has to return five players, one for each position. Create a function which provides monthly validation if some of the teams breached a contract limit. This function should generate luxury tax record. Create a query which provides information which teams went over the budget limit for during the season. Create a list of most expensive teams and most expensive player. Read - replica database on the same machine. Replication needs to be as real-time as possible. Automatic backups of the database every two hours.