Scenario

A football academy is a dedicated institution that nurtures and develops young football talent. These academies provide a structured environment for individuals to enhance their football skills and game knowledge. The primary objective is to prepare aspiring football players for competitive matches at the youth level, professional clubs, or international competitions. Typically, football academies offer coaching, physical conditioning, competitive games, and educational support to provide a comprehensive platform for player development.

To efficiently oversee the development and performance of players, assess coaching staff, schedule training sessions and matches, and ensure the proper utilisation and maintenance of the training facilities, making the management of the football academy more effective and organised. A football academy should be able to view detailed profiles for each enrolled player, including their name, date of birth, contact information, medical history, position, and performance statistics.

Additionally, a football academy should have access to coaching staff information. Coaching staff information might include coach names, contact details, coaching certifications, coaching history, and the specific teams or age groups they are responsible for.

To analyse training session data, a football academy should record important session details such as date, time, location, and the type of session $($whether it's focused on drills, scrimmage, or fitness$).$ Concerning matches, a football academy should track the competitive performance of its teams. Data captured by the football academy might include the games played by our academy, including the opponent, date, location, match outcomes, goals scored, and goals conceded.

Lastly, a football academy captures information about the various facilities available, including the facility name, location, field type $($grass or turf$),$ seating capacity, and maintenance schedule.

$$

Use the information above to attempt the following.

Use the information from above and your knowledge of databases to determine five database entities for a football academy. For each of the entities, summarise the information that the entity stores and all the attributes of the entity.

Determine three business rules for each entity mentioned in the football academy scenario above.

Draw an Entity Relationship Diagram of the system database.

How will the database be used by coaches, players, parents, and administrators?