Super Baseball League

Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment:

The database keeps track of the history of all of the teams that each player has played on and all of the players who have played on each team.

The database only keeps track of the current team that a coach works for.

Team Number, Team Name, and Player Number are each unique attributes across the league.

Coach Name is only unique within a team (and we assume that a team cannot have two coaches of the same name.)

Serial Number (for bats) is only unique within a team.

In the AFFILIATION relation, the Years attribute indicates that number of years that a player played on a team; the Batting Average is for the years that a player played on a team.

My questions are:

a.In BATS Relation, which one is a primary key and which is an alternate key? And why?

b.How many foreign keys does each relation have? Identify the foreign keys of each relation.

c.Indicate any instances in which a foreign key serves as part of the primary key of the relation in which it is a foreign key. Why does each of those relations require a multi-attribute primary key?

d.Identify the relations that support many-to-many relationships, the primary keys of those relations, and any intersection data.

e.As follows image:

TEAM Relation TEAM NUM- CITY MANAGER Gomez Carter Baker Franklin Smith Jones Edwards Adams Vega TEAM NAME Des Moines Memphis Dallas Atlanta Orlando San Jose Springfield El Paso Jackson 10 Dodgers 15 Giants 23 Bluebirds 85 Turkeys 137 Eagles 275 Cowboys 294 Statesmen 368 Pandas 422 Sharks