1. Give an E/R diagram for a database recording information about teams, players, and their fans who are season ticket holders including: 1. For each team, its name, its players, its team captain (one of its players), and the colors of its uniform. 2. For each player, his name. 3. For each fan, his/her name, favorite teams, and favorite players 4. Assume each fan has a unique season ticket number. 5. Assume each player has a unique name for this exercise. Remember that a set of colors is not a suitable attribute type for teams and you have to get around this restriction. Underline the primary keys in your E/R diagram and indicate any many-one or one-one relationships by using arrows. 2. Suppose we want to add to the schema of problem 1 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.