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 30 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 30 characters) and a phone number (with the format (999) 999-9999). All clubs have an abbreviation of maximum 5 characters. Some clubs may have the same abbreviation.

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 22 characters. All teams have an email and phone contact stored in a similar way with the club contact information.

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. Can you make this design assignment in SQL workbench, please