Reference no: EM132218533
The business rules and instructions for creating your ERD:
Each player is expected to attend all 20 training sessions. For each training session to go ahead, six or more players must register to attend it.
Every training session is identified by a training session ID. The date, time and venue are also kept in the system for each training session. Each player is identified by a player ID.
For each player, the player's name, DOB and playing position are recorded in the system. An important training session's detail is that the system also takes note of the players who attended each training session and the rating of the performance that each player gives at the end of each training session.
Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule.
NOTE
Use Crows Foot notations
Include the PKs where appropriate
Any M:N relationship is to be resolved to a 1:M relationship
Manually drawing the ERD is NOT acceptable.