Training Sessions Database ERD Diagram Project and Business Rules

This project provides ERD diagrams designed according to specified business rules for a training sessions database. The first business rule dictates that each player attends all 20 training sessions, which is reflected in the ERD by linking the Player and Training Session tables through a Performance table to avoid a many-to-many relationship. The second business rule requires each training session to have at least six registered players. Assumptions made include attributes in the Player table (training_sessions_attended) and Training_session table (number_of_players) to enforce these rules. The relationships between Player, Training_session, and Performance are one-to-many, with cardinalities and optionalities reflecting the ability of one player to attend many sessions and one session to include many players, with performance ratings stored in the Performance table. Desklib offers a wealth of resources for students, including past papers and solved assignments.