Recall the ERD exercise problem:

Leagues: Leagues have a name. League names are unique.

Teams: Teams have names, players, a captain (who is also a player) and uniform colors. No league has two teams with the same name. But there can be teams with the same name in different leagues.

Each team has uniforms of one or more colors.

There are two types of teams, sponsored and not sponsored. A sponsored team has a sponsoring company with the company contact person.

Players: Players have a number and a name. No team has two players with the same number. However, there can be players with the same number on different teams.

Fans: Fans have a name, a favorite team, and a favorite color. A suggested ERD is given below.

Please transform the ERD into relations.

Clearly indicate primary/foreign keys.

Fan1D Favorite Color )+ Fan Name Favonite Team Color Has Name Contact Person Has Team By Company League Name Team Name Has Number Player Leads Player ID