Based on the Entities, Attributes and business rules create an ERD with the appropriate cardinalities

Entities and Attributes

1. Team

• TeamID

1. Unique Integer, not null
2. Represents unique ID for teams and is the Primary Key

• TeamName

1. Text
2. Represents the name of the team with a specific Primary Key

• League

1. Text
2. Represents the League team is in with a specific Primary Key

• StadiumName

1. Text
2. Represents the name of the stadium of a team with a specific Primary Key

• StadiumCapacity

1. Must be a positive integer
2. Represents the number of people the stadium of a team can hold with a specific Primary Key

1. Players

• PlayerID

1. Unique Integer, not null
2. Primary Key, and the unique ID given to a specific Player

• PlayerName

1. Text
2. Name of a player with a specific Primary Key

• Position (forward, midfielder, defender, goalkeeper)

1. Must be a valid position ( Forward, Midfielder, Defender, or GoalKeeper)
2. SuperType that represents a certain position of a player with a specific Primary Key

• PreferredFoot (Left, Right)

1. Must be a valid selection: Left or Right
2. SuperType of the footedness of a player with a specific Primary Key

• Height

1. Must be a positive integer
2. Height of a player with a specific Primary Key

• Weight

1. Must be a positive integer
2. Weight of a player with a specific Primary Key

1. Coach

• CoachID

1. Unique Integer
2. Unique ID of a specific coach

• CoachName

1. Text
2. Name of a coach with a specific Primary Key

• ContractYearsLeft

1. Must be a positive integer and greater than zero
2. Years of a contract left of a coach with a specific Primary Key

• HireDate

1. Must be a valid date
2. Date a coach with a specific Primary Key was hired

• CoachingWins

1. Positive Integer
2. Wins accumulated by a coach with a specific Primary Key

• CoachingLosses

1. Positive Integer

1. Matches

• MatchID

1. Unique Integer, not null
2. Unique ID of a specific match

• Date

1. Must be a valid date
2. Date of a match with a specific Primary Key

• Location

1. Text
2. Location of a match with a specific Primary Key

• Opponent

1. Text
2. Name of the opponent played against in the match with a specific Primary Key

• HomeTeamGoals

1. Must have a positive integer, must be greater than or equal to zero, cannot be null
2. Number of goals the home team has scored in a match with a specific Primary Key

• AwayTeamGoals

1. Must have a positive integer, must be greater than or equal to zero, cannot be null
2. Number of goals an away team has scored in a match with a specific Primary Key

1. Staff

• StaffID

1. Unique Integer, not null
2. Unique ID of specific staff members

• Name

1. Text
2. Name of a staff member with a specific Primary Key

• Role (AssistantCoach, FitnessTrainer, Scout)

1. Must be a valid role: AssistantCoach, FitnessTrainer, Scout
2. SuperType that represents the role of a staff member with a specific Primary Key.

• DateHired

1. Must be a valid date
2. Date a staff member with a specific Primary key was hired

• Salary

1. Positive Integer
2. Salary of a staff member with a specific Primary Key

1. Sponsors

• CompanyID

1. Unique Integer, not null
2. Unique ID of the company sponsoring the team

• CompanyName

1. Text
2. Name of the company sponsoring with a unique Primary Key

• Industry

1. Text
2. The industry of the company sponsoring with a unique Primary Key

• SponsorshipAmount

1. Positive Integer
2. Amount of money a company with a unique Primary Key is sponsoring with

• SponsorshipYearsLeft

1. Positive Integer, Must be greater than 0
2. Amount of years left for a company with a unique Primary Key has agreed to sponsor

• AssetsSponsored (stadium, jersey, training ground)

1. Must be valid selection: Stadium, Jersey, Training Ground
2. SuperType of the specific asset a company with a unique Primary Key is sponsoring