Question: Question4. (30 points) Consider a database to store information about a Sports Organization. The database has the following properties: - Each league has a name

Question4. (30 points) Consider a database to store information about a Sports Organization. The database has the following properties: - Each league has a name and unique league number - A league may be affiliated with one or more teams. - Frery team is affiliated with exactly one league. - Xe store the name, colors, and unique team_id for each team. - 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 managers, we record their annual bonus. - Both players and managers are employees. - For each employee, we store a name, salary, and unique employee id. Consider the following ER model. Please complete the diagram to capture the ab information. Please include all the missing relationships and indicate any key and participation constraints. employeelD
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
