Assignment task: What will be the Entity Relationship Diagram (diagram only) for this question below:
Scout programs are organized around regional districts that each contains numerous troops (a local group of youth and adult members).
Business rules:
1. Each troop has numerous members in the form of scouts (youth members) and a variety of leaders (adult members), including Scoutmasters and Assistants
2. Leaders are associated with no more than one troop and may temporarily not be associated with a troop
3. Troops can't be created without at least one leader but can have many leaders
4. Troops can't be created without at least one scouts but can have many scouts
5. Scout data can't be entered without a troop assignment (one troop)
6. Each district has numerous campsites which can be reserved by a leader and a scout acting together
7. Leaders and scouts are able to check out multiple campsites
8. Campsite reservations must be able to be identified by data as well as by the leader and scout who made the reservation, and must include data detailing the start date and end date for the reservation. Each reservation needs to have one leader, scout and camp site.
9. Define Reservation as a separate entity with it's own unique id (as an associate entity)
Your goal: To draw a practical ERD to be used by the Arrowhead District to manage troops, leaders, scouts, and campsite reservations in the district.