Ideas For Database Enhancement: 1253929

a) Additional Query implement to get the number of jobs done by each volunteer:

This additional query provides the insight about how many jobs are done by each volunteers. This query sort the jobs in decending order and give the name of the volunteer who is doing most jobs.

b)  Hierarchical Form: This Resident and Job hierarchical form provides the details about how many jobs are posted by resident and which volunteer has done those jobs and at what time.

c) The suggestion is for job table that it should also include the job description which gives insight on the job and another suggestion is for Volunteer table instead of having all the availability column in the same table, there should be separate table for availability and volunteer_id must act as foreign key for that table.