Question: cenario 3 : Campsite Reservations ( 1 0 points ) Scout programs are organized around regional districts that each contains numerous troops ( a local

cenario 3: Campsite Reservations (10 points)
Scout programs are organized around regional districts that each contains numerous troops (a local
group of youth and adult members).
Business rules:
Each troop has numerous members in the form of scouts (youth members) and a variety of
leaders (adult members), including Scoutmasters and Assistants
Leaders are associated with no more than one troop and may temporarily not be associated
with a troop
Troops can't be created without at least one leader but can have many leaders
Troops can't be created without at least one scouts but can have many scouts
Scout data can't be entered without a troop assignment (one troop)
Each district has numerous campsites which can be reserved by a leader and a scout acting
together
Leaders and scouts are able to check out multiple campsites
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.
Define Reservation as a separate entity with its 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. i want with ERD picture please. here the whole information for question(Scenario 3: Campsite Reservations (10 points)
Scout programs are organized around regional districts that each contains numerous troops (a local
group of youth and adult members).
Business rules:
Each troop has numerous members in the form of scouts (youth members) and a variety of
leaders (adult members), including Scoutmasters and Assistants
Leaders are associated with no more than one troop and may temporarily not be associated
with a troop
Troops can't be created without at least one leader but can have many leaders
Troops can't be created without at least one scouts but can have many scouts
Scout data can't be entered without a troop assignment (one troop)
Each district has numerous campsites which can be reserved by a leader and a scout acting
together
Leaders and scouts are able to check out multiple campsites
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.
Define Reservation as a separate entity with its 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.
... so please draw the ERD and what note do i need to add the shape?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!