Reference no: EM132637505

Crow's Foot National Soccer League (NSL) database system description:

Please create high level ERD using notation conceptual model for the National Soccer League (NSL) database system using the description given below.

The NSL has many teams, each team has a name, a city, a coach (just the coach name), a captain, and a group of players. Each player plays for only one team, and he has a name, a position (e.g., left wing, goalkeeper, ..., etc.), a skill level (rating, a number between 0-10), and zero or more history records (information about previous teams, injuries, prizes, achievements, ..,etc.). Each history record has a description and a start and an end dates of the event (e.g. "Man of the match", "09/12/2019","09/12/2019"). One of the players is designated as the team captain. The system needs to record information about each game played in the NSL. Each game is scheduled to be played between two teams at certain field (identified by a name, associated team, and location) on certain date. The team associated with the field is referred to as the "host team" and the other team as the "guest team". For each game, the score, the winner, and the time, team, and scorer of each goal should be recorded.

Task:

Your task is to create conceptual model for the National Soccer League (NSL) database system using the description given below. Your answer should include:

1. The main entities and their attributes

2. All the relationships between the identified entities, their cardinalities, and their attributes if there is any relationship with attributes.

3. The model must contain logical level details (keys and main attributes)