Create two ER diagrams based on the customer requirements. One will be an ER diagram for volunteers and organization. The other will be an ER diagram for volunteer research manager and other volunteers. I do not know how much information you guys need to do this, so I screenshotted the whole project. Please help and I will definitely give a like!!!!!!!!!!!!!

Page of 6 ZOOM Business Case for Project Name-DB Tool for Volunteer Resource Management Prepared by: Karin Weichlein 1.0 Introduction/ Background Corporate social responsibility can be shown in many ways. Companies are asked to become actively involved in community service activities or provide sponsorships in support of major events. Community organizations hold fundraisers events, from school sports teams to local charities, from racing events to cultural spectacles. Companies are asked to donate money, product, service, employee volunteers to support the community causes. Companies that are interested in providing sponsorship to such events are looking for assurances that their investment creates positive consumer awareness and good PR Whether community events are large festivals or sport events, charity fundraisers or a carnival to support a local or national cause, they require volunteers to run an ellicient operation Kcy: Volunteer resource management is an intricatc process. The success of an event depends on synchronizing their schedule with the overall event organization, recruiting the right number of volunteers, assigning and matching the skills, managing, and rewarding the volunteer team. The concept of turnkey and outsourcing solutions is well understood in the private and public business sector, but has not been widely explored the non-profit and volunteer resource management areas. Today, most volunteer coordinators still work off spreadsheets to assign and track their volunteers. Volunteers are often not prepared for their task, disappointed because their time commitment has been exceeded, or feel like they wasted their time. 2.0 Purpose of the Database Tool for Volunteer Resource Management The Database Tool for Volunteer Resource Management is the central repository for volunteer and event information. It will allow the organization of data by event and volunteer job functions and shifts. Page of 6 ZOOM Key: It will serve as a repository to collect volunteer personal data, availability, interests, preferences for jobs or time shifts and allow the Volunteer Resource manager to qucry. pull, sort, gcncratc reports on volunteers as thcy arc associated to an event. It becomes the central tool for sourcing and managing the volunteers through information contained in the volunteer CRM. The Volunteer Resource manager will be able to: 1 Gencratc forms, qucrics and reports for individual and total events Gencratc a Volunteer sign up form for individual cvents Volunteers will be able to sign up for events Query the status of volunteers per event. Additional benefits from storing historic data: Create historic data to use for costing proposals, developing Statement of Work, forecasting volunteer requirements Create a repository store and manage the relationship with volunteers Identify target volunteers to recruit for future event Inventory total volunteer hours for statistical reporting on economic impact Accrue and reward a volunteer after x hours volunteered (congrats, qualifies for reward, eligible for bigger span of control) . . 3.0 Current Situation and Problem/Opportunity Statement Page of 6 ZOOM Current Situation: The business manages definitions of volunteer jobs required, email notification to volunteers, shift requests, information updates, confirmation of volunteer assignment through individual word or excel documents. Sometime free tools such as Eventbrite or Signup Genius are used to support the shift requirement communication. No time accrual. Problem: Tracking management time on excel sheets Scarch time for documents on computer Risk of error when reusing templates Not scalable Not easy to use by additional team members. Time spent on setting up Google Drive and other shared workspace environments Must search through individual event lists to find phone numbers or emails Opportunity Single repository for event and volunteer information Easy scarch functions in central locations Email list to populate Mail Chimp or other service to send out mass emails or newsletter updates Scalable to start adding additional regions for events and grow the DB Easy search criteria to find team leads, special skills, time availability, geographic information, preferences, contact information 4.0 Critical Assumption and Constraints for entities, attributes, relationships and constraints 2 Page of 6 ZOOM Attributes: Key: 3 main categories: Event (date, schedule, location, type, organizers/sponsors/venue, management time), volunteers (personal data, available times, assignment preferences), assignment (job description, shifts, filled/open) Name City Address Email and cell phone Must 1 be able to add Events and retire events once they are completed Type of Event (race, festival, conference, theatre, indoor, outdoor etc) and a description Must be able to search by event, event name, event location, city Location of Event Event Promoter or organizer and their website/contact name Venues and their website/contact name Charities and their website/contact name Sponsors and their website/contact name Total sponsorship per event Event duration Ta of volunteer job a volunteer performed Assignments per even Shift per Assignment per volunteer per event Shifts of volunteering per volunteer per event Training requirement per cvent Training date(s) per event Total hours per Total hours volunteered per event of participants Number of spectators Total number of volunteers per event Total number of shifts per event Total hours volunteer resource management time per event Retired or archive events only if a wrap up report is filed Tracking management time per event Assi per assignment per event per volunteer Number of Relationship Assumptions: This is a data model that comes pretty close to capturing relationships in what we do for volunteer resource management: Page of 6 ZOOM http://www.databaseanswers.org/data_models/organisations and people/index.htm Relationship name, email, home address to event location Volunteer can have 1 address, 1 cell phone, 1 email Volunteer can have 0 hours or many volunteer hours 3 Establish a relationship between the name of a volunteer, events that they volunteered at, shift times and job function 1 event can be associated to many shifts and 1 volunteer can have multiple shifts throughout l event Total hours for 1 event can only be associated to 1 event, must be able summarize total volunteer hours by regional location and by event promoter Establish a relationship between Event promoter, location or venue, type of event Establish a relationship between event, schedule, shifts There is a relationship between shifts, volunteer jobs, hours volunteered Search for names and emails of people who have done certain volunteer jobs, events, or geographic locations in the past to create a recruiting email blast Would be great if you can send out confirming emails for signed up and accepted shifts Administrative rights to the data Volunteers should be able to search for events that may interest them in their area (.e. Venice, Sarasota, Bradenton, Tampa) Constraints: Page > of 6 ZOOM Constraints: The system is protected and available only after authenticating by using User Name and Password. The application is available as a web page. Connection to the Internet is nccessary. o Only authorized administrators can: Query, add, update, and remove volunteers Volunteer status -registered, approved, blocked, assigned to an cvent Event cancelled Access volunteers personal data When a volunteer has signed up for an event, they should be able to see only that event not any others Volunteer should not be able to sign up for conflicting shift times, days or location Only admin should have access to organizer, promoter, personal data of volunteers Admin should be able to assign Team Captain access to their team that is working an event to send email, updates, noles, shill changes Upon the user entering their Login and Password the system shall authenticate the user checking for a valid Login ID and Password. If the user enters an invalid Login or Password then a message shall be displayed indicating that the login attempted failed. If the same Login ID failed 3 times in a row then that ID must be locked out. A message shall be displayed indicating that the maximum number of failed Login attempts has been rcached and an administrator must reset thc Login ID. Else if the user is valid then they shall be presented with their appropriate entry screen. If the user is logging into the application for the first time they must Page of 6 ZOOM be prompted to change their password 5.0 Analysis of Option and Recommendation Easy to use interface Start with a repository for events, volunteers, type of assignments, and shifts Ability to extract email and contact information from a large pool of volunteers and email broadcast message Easy to follow user directions since 6.0 Preliminary Project Requirements Fields for 3 main categories: Event (date, schedule, location, type, organizers/sponsors/venue), Volunteers (personal data, available times, assignment preferences), assignment (job description, shifts, filled/open) Extract reports into cxcel or other report format Ability to add and retire fields in the 3 main categories Cancel options to return to previous screen No more than two clicks to get from login to desired category (create volunteer profile, look up event, look up volunteer opportunities, assign volunteers, change/update assignment 7.0 Schedule Estimate Will depend on the class project schedule this semester 8.0 Potential Risks Trying to be too complex. Need to incorporate available plug-ins compatible with Wordpress to integrate with evolving website. Not setting expectations and a reasonable timetable with milestones Not having appropriate user testing and building in time to fix bugs Re-inventing the wheel - there are good free solutions that offer key elements through i.e. Signup Genious, Constant Contact, MailChimp - but they are not proprietary. If they go out of business - I loose all the valuable information and history Not getting the basics right jeopardizing opportunity to have differentiating features 9.0 Exhibits Attachment: Excel Management Timesheet Page of 6 ZOOM Business Case for Project Name-DB Tool for Volunteer Resource Management Prepared by: Karin Weichlein 1.0 Introduction/ Background Corporate social responsibility can be shown in many ways. Companies are asked to become actively involved in community service activities or provide sponsorships in support of major events. Community organizations hold fundraisers events, from school sports teams to local charities, from racing events to cultural spectacles. Companies are asked to donate money, product, service, employee volunteers to support the community causes. Companies that are interested in providing sponsorship to such events are looking for assurances that their investment creates positive consumer awareness and good PR Whether community events are large festivals or sport events, charity fundraisers or a carnival to support a local or national cause, they require volunteers to run an ellicient operation Kcy: Volunteer resource management is an intricatc process. The success of an event depends on synchronizing their schedule with the overall event organization, recruiting the right number of volunteers, assigning and matching the skills, managing, and rewarding the volunteer team. The concept of turnkey and outsourcing solutions is well understood in the private and public business sector, but has not been widely explored the non-profit and volunteer resource management areas. Today, most volunteer coordinators still work off spreadsheets to assign and track their volunteers. Volunteers are often not prepared for their task, disappointed because their time commitment has been exceeded, or feel like they wasted their time. 2.0 Purpose of the Database Tool for Volunteer Resource Management The Database Tool for Volunteer Resource Management is the central repository for volunteer and event information. It will allow the organization of data by event and volunteer job functions and shifts. Page of 6 ZOOM Key: It will serve as a repository to collect volunteer personal data, availability, interests, preferences for jobs or time shifts and allow the Volunteer Resource manager to qucry. pull, sort, gcncratc reports on volunteers as thcy arc associated to an event. It becomes the central tool for sourcing and managing the volunteers through information contained in the volunteer CRM. The Volunteer Resource manager will be able to: 1 Gencratc forms, qucrics and reports for individual and total events Gencratc a Volunteer sign up form for individual cvents Volunteers will be able to sign up for events Query the status of volunteers per event. Additional benefits from storing historic data: Create historic data to use for costing proposals, developing Statement of Work, forecasting volunteer requirements Create a repository store and manage the relationship with volunteers Identify target volunteers to recruit for future event Inventory total volunteer hours for statistical reporting on economic impact Accrue and reward a volunteer after x hours volunteered (congrats, qualifies for reward, eligible for bigger span of control) . . 3.0 Current Situation and Problem/Opportunity Statement Page of 6 ZOOM Current Situation: The business manages definitions of volunteer jobs required, email notification to volunteers, shift requests, information updates, confirmation of volunteer assignment through individual word or excel documents. Sometime free tools such as Eventbrite or Signup Genius are used to support the shift requirement communication. No time accrual. Problem: Tracking management time on excel sheets Scarch time for documents on computer Risk of error when reusing templates Not scalable Not easy to use by additional team members. Time spent on setting up Google Drive and other shared workspace environments Must search through individual event lists to find phone numbers or emails Opportunity Single repository for event and volunteer information Easy scarch functions in central locations Email list to populate Mail Chimp or other service to send out mass emails or newsletter updates Scalable to start adding additional regions for events and grow the DB Easy search criteria to find team leads, special skills, time availability, geographic information, preferences, contact information 4.0 Critical Assumption and Constraints for entities, attributes, relationships and constraints 2 Page of 6 ZOOM Attributes: Key: 3 main categories: Event (date, schedule, location, type, organizers/sponsors/venue, management time), volunteers (personal data, available times, assignment preferences), assignment (job description, shifts, filled/open) Name City Address Email and cell phone Must 1 be able to add Events and retire events once they are completed Type of Event (race, festival, conference, theatre, indoor, outdoor etc) and a description Must be able to search by event, event name, event location, city Location of Event Event Promoter or organizer and their website/contact name Venues and their website/contact name Charities and their website/contact name Sponsors and their website/contact name Total sponsorship per event Event duration Ta of volunteer job a volunteer performed Assignments per even Shift per Assignment per volunteer per event Shifts of volunteering per volunteer per event Training requirement per cvent Training date(s) per event Total hours per Total hours volunteered per event of participants Number of spectators Total number of volunteers per event Total number of shifts per event Total hours volunteer resource management time per event Retired or archive events only if a wrap up report is filed Tracking management time per event Assi per assignment per event per volunteer Number of Relationship Assumptions: This is a data model that comes pretty close to capturing relationships in what we do for volunteer resource management: Page of 6 ZOOM http://www.databaseanswers.org/data_models/organisations and people/index.htm Relationship name, email, home address to event location Volunteer can have 1 address, 1 cell phone, 1 email Volunteer can have 0 hours or many volunteer hours 3 Establish a relationship between the name of a volunteer, events that they volunteered at, shift times and job function 1 event can be associated to many shifts and 1 volunteer can have multiple shifts throughout l event Total hours for 1 event can only be associated to 1 event, must be able summarize total volunteer hours by regional location and by event promoter Establish a relationship between Event promoter, location or venue, type of event Establish a relationship between event, schedule, shifts There is a relationship between shifts, volunteer jobs, hours volunteered Search for names and emails of people who have done certain volunteer jobs, events, or geographic locations in the past to create a recruiting email blast Would be great if you can send out confirming emails for signed up and accepted shifts Administrative rights to the data Volunteers should be able to search for events that may interest them in their area (.e. Venice, Sarasota, Bradenton, Tampa) Constraints: Page > of 6 ZOOM Constraints: The system is protected and available only after authenticating by using User Name and Password. The application is available as a web page. Connection to the Internet is nccessary. o Only authorized administrators can: Query, add, update, and remove volunteers Volunteer status -registered, approved, blocked, assigned to an cvent Event cancelled Access volunteers personal data When a volunteer has signed up for an event, they should be able to see only that event not any others Volunteer should not be able to sign up for conflicting shift times, days or location Only admin should have access to organizer, promoter, personal data of volunteers Admin should be able to assign Team Captain access to their team that is working an event to send email, updates, noles, shill changes Upon the user entering their Login and Password the system shall authenticate the user checking for a valid Login ID and Password. If the user enters an invalid Login or Password then a message shall be displayed indicating that the login attempted failed. If the same Login ID failed 3 times in a row then that ID must be locked out. A message shall be displayed indicating that the maximum number of failed Login attempts has been rcached and an administrator must reset thc Login ID. Else if the user is valid then they shall be presented with their appropriate entry screen. If the user is logging into the application for the first time they must Page of 6 ZOOM be prompted to change their password 5.0 Analysis of Option and Recommendation Easy to use interface Start with a repository for events, volunteers, type of assignments, and shifts Ability to extract email and contact information from a large pool of volunteers and email broadcast message Easy to follow user directions since 6.0 Preliminary Project Requirements Fields for 3 main categories: Event (date, schedule, location, type, organizers/sponsors/venue), Volunteers (personal data, available times, assignment preferences), assignment (job description, shifts, filled/open) Extract reports into cxcel or other report format Ability to add and retire fields in the 3 main categories Cancel options to return to previous screen No more than two clicks to get from login to desired category (create volunteer profile, look up event, look up volunteer opportunities, assign volunteers, change/update assignment 7.0 Schedule Estimate Will depend on the class project schedule this semester 8.0 Potential Risks Trying to be too complex. Need to incorporate available plug-ins compatible with Wordpress to integrate with evolving website. Not setting expectations and a reasonable timetable with milestones Not having appropriate user testing and building in time to fix bugs Re-inventing the wheel - there are good free solutions that offer key elements through i.e. Signup Genious, Constant Contact, MailChimp - but they are not proprietary. If they go out of business - I loose all the valuable information and history Not getting the basics right jeopardizing opportunity to have differentiating features 9.0 Exhibits Attachment: Excel Management Timesheet Page