Question

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.

Answer 1