Assignment 8

Views and Indexes

1. Create a view which lists all the donors with their addresses

2. Create a view that lista all the donors and their email addresses (exclude those without)

3. Create a view that shows a total of all donations grouped by the employee that took them in

4. Add an index for each foriegn key in each of the tables