Question

1. Case 1: Consider a database to store information about a Sports Organization. The database has the following properties: • Each league has a name and unique league ID (integer). The 'NFL' (National Football League) is an example of a sports league. • A league may be affiliated with one or more teams. • Every team is affiliated with exactly one league. • We store the name, colors, and unique team ID (integer) for each team. For example, the name of Pittsburgh's football team is the 'Steelers' and their team colors are 'black & gold'. • A team has exactly one home stadium. A stadium may be a home to zero or more teams. For example, the home stadium of the Pittsburgh's baseball team, the Pirates, is 'PNC Park'. • For home stadiums, we record a city, name, and unique stadium ID (integer). • A team has at least one player, and a player plays for exactly one team. • A team has exactly one manager, and a manager manages exactly one team. • Every player has a number and a position. For example, Pittsburgh Steelers player Ben Roetblisberger has the number 7 and his position is 'quarterback'. • For managers, we record the dollar amount of their annual bonus. • Both players and managers are types of employees. • For each employee, we store a name, salary, and unique employee ID (integer). Given this description of the database and its constraints, create the mostly correct Entity-Relationship Diagram.

          1. Case 1: Consider a database to store information about a Sports Organization. The database has the following properties:
• Each league has a name and unique league ID (integer). The 'NFL' (National Football League) is an example of a sports league.
• A league may be affiliated with one or more teams.
• Every team is affiliated with exactly one league.
• We store the name, colors, and unique team ID (integer) for each team. For example, the name of Pittsburgh's football team is the 'Steelers' and their team colors are 'black & gold'.
• A team has exactly one home stadium. A stadium may be a home to zero or more teams. For example, the home stadium of the Pittsburgh's baseball team, the Pirates, is 'PNC Park'.
• For home stadiums, we record a city, name, and unique stadium ID (integer).
• A team has at least one player, and a player plays for exactly one team.
• A team has exactly one manager, and a manager manages exactly one team.
• Every player has a number and a position. For example, Pittsburgh Steelers player Ben Roetblisberger has the number 7 and his position is 'quarterback'.
• For managers, we record the dollar amount of their annual bonus.
• Both players and managers are types of employees.
• For each employee, we store a name, salary, and unique employee ID (integer).
Given this description of the database and its constraints, create the mostly correct Entity-Relationship Diagram.

1. Case 1: Consider a database to store information about a Sports Organization. The database has the following properties:
• Each league has a name and unique league ID (integer). The 'NFL' (National Football League) is an example of a sports league.
• A league may be affiliated with one or more teams.
• Every team is affiliated with exactly one league.
• We store the name, colors, and unique team ID (integer) for each team. For example, the name of Pittsburgh's football team is the 'Steelers' and their team colors are 'black gold'.
• A team has exactly one home stadium. A stadium may be a home to zero or more teams. For example, the home stadium of the Pittsburgh's baseball team, the Pirates, is 'PNC Park'.
• For home stadiums, we record a city, name, and unique stadium ID (integer).
• A team has at least one player, and a player plays for exactly one team.
• A team has exactly one manager, and a manager manages exactly one team.
• Every player has a number and a position. For example, Pittsburgh Steelers player Ben Roetblisberger has the number 7 and his position is 'quarterback'.
• For managers, we record the dollar amount of their annual bonus.
• Both players and managers are types of employees.
• For each employee, we store a name, salary, and unique employee ID (integer).
Given this description of the database and its constraints, create the mostly correct Entity-Relationship Diagram.

Added by Tanya M.

Question

Please give Ace some feedback