Create a database design and create a short PDF report presenting your design. Your design will contain the representation of a simple database for the provided specification.

Requirements Specification (this is a fictional scenario)

A young soccer league wants to manage its registrations.

The league function based on seasons, like FALL 2020. For each season there is a registration starting date and ending date and also a season starting date and ending date. The league may want to compare FALL seasons in different years. The seasons are FALL, SPRING, WINTER and SUMMER.

In each season, the league has several divisions organized based on age (e.g. U14), players sex (e.g. boys, girls) and rank (e.g. 1, 2). For a division we will keep a unique contact email (of maximum 25 characters) and phone (with the format 999-999-9999)for the teams to report results.

The league has many clubs. For a club we will keep the name of the club (e.g. Patriots) (of maximum 20 characters), a contact email (of maximum 25 characters) and a phone number (with the format 999-999-9999). Some clubs have an abbreviation of maximum 5 characters.

A club has many teams, and a team belongs to a single club. Teams are organized based on players birth year (e.g. 2007) and players sex (e.g. boys, girls) and they have a unique name within the club (e.g. BLUE) of maximum 20 characters.

Each team has a current team manager, which can manage a single team. About the team manager we keep the name (of maximum 40 characters), phone (with the format 999-999-9999) and email (of maximum 25 characters). There are no special searches or processing based on the first name or last name of the manager. You cannot have a team without a team manager.

Each season (e.g. FALL 2020 or SPRING 2019), a registered team is assigned to a given division, that may change in rank based on the results obtained in the previous season. The league wants to keep the history of the membership (registration) over time.

When a new season is created, there are no divisions. Then the divisions in the season are created. After that the teams are registered in the corresponding division. When a new club is added there are no teams. Then the teams are added one by one. Your design must support this iterative process.