Database system - Create the conceptual and logical designs

DARM is a university which wants to develop a database application for their soccer tournaments.

The following are the requirements of the database application. Read the requirements and submit the conceptual and logical designs.

( Requirements or business rules )

* Each year a number of soccer tournaments are organized by DARM . Each tournament is given a name, a number, and starts and ends at predefined dates.

* A number of teams participate in each tournament. Each team has a name, a number, an address, contact numbers, a website, an email address, a main coach, a manager, and a number of players.

* Each player must be a DARM student, faculty, or staff. Each player has a DARM ID, a team number, a name, a date of birth, a type (student, faculty, or staff), email address, one or more telephone numbers, and a department. A player can only be in one team in a tournament but he can be in a different team in another tournament.

* A number of matches are conducted in each tournament. Each match is played by two teams at a date, time, and field decided before the start of the first match of the tournament. Also, the referees and the team leaders of each match are decided before the first match of the tournament. After each match the best player is selected.

* The goals scored by each team in a match are recorded. The time and the scorer of each goal scored in a match are also recorded.

* The red and the yellow cards given to each player at a tournament are recorded. The following rules are applied within a tournament (i.e. they will not apply across tournaments):

- A player will miss the next two matches if he takes a red card in a match.

- A player will miss the next match once he takes the second yellow card in a tournament.

* The names, DARM IDs, and contacts of team managers, coaches, and referees are known before the first match of the tournament.

* There are a number of DARM fields were matches are played. Each field has a name, number, description, and status (active, inactive).

please do like them.