Using the staff data and group data tabs, create a security model that is consistent with the needs of the business.  Remove as few group memberships as possible and create as few SQL queries as possible.

Using the staff data and group data tabs, create a security model that is consistent with the needs of the business. 
Remove as few group memberships as possible and create as few SQL queries as possible. Assign each group an SQL query that meets the conditions for the group, unless it's memberships already meet the conditions. Ensure that no users are granted access
that violates the conditions, and that each user is only granted access once.(i.e. a user should not get access to a group through 2 different paths). Produce an Organization Chart from the staff data. Produce a drawing that outlines your group solution as a network of granting access. Produce a written explanation of your model and why any changes you make are necesarry.  Produce a staff list with the groups each user should recieve based on your model
Use whatever tools you feel comfortable with.

Staff Data and Group Data are locked to preserve data integrity. Feel free to copy the data into the worksheet or other tabs.