This was my final project for a T-SQL class.
This is a fully t-sql Non-profit Organization database. It stores not just the volunteers for the different departments/organizations but the information of the people taking part in their services and the history of their dispersments. There are 2 major procedures incorperated into this database; scheduling and client insertion.
The first is tracking households and the members of the households, for the clients of the non-profit. When adding someone into the database it will look first to compare addresses to see if an adress exists already. If the adress exists it will compare last names and other factors to determine the exact household relation, like child, roommate, partner or spouse.
The second major procedure is the scheduling procedure. All volunteers enter an availability schedule that would generally not change, and enter any special requests into the system. An administator would enter the departments/organizations they are certified to work in. The scheduler will make a schedule for all departments starting with the department with the least number of certified volunteers. The procedure takes into consideration; noone is working over 10 shifts or 40 hours, noone is working on a day they are not able either through special request or normal availability, and noone is working in a department that they are not certified for.