(adding to this ER diagram)

Exercise 4.1.4: Suppose we wish to add to the schema of Exercise 4.1.3 a

relationship Led-by among two players and a team. The intention is that this

relationship set consists of triples (player1, player2, team) such that player 1

played on the team at a time when some other player 2 was the team captain.

a) Draw the modification to the E/R diagram.

b) Replace your ternary relationship with a new entity set and binary relationships.

! c) Are your new binary relationships the same as any of the previously existing

relationships? Note that we assume the two players are different,

i.e., the team captain is not self-led.

color name Colors FavorateColor Fans Favorate Team UniformColor FavoratePlayer SSN# name name Teams Contracts Players CaptainOF Captains