Community Assist is a non-profit that takes donations from the public and then uses the donations to provide one time grants to members of the community. They have a few business rules.
- 90% of all donations go to grants
- 10% is used to support the non-profit
- The maximum one-time grant is $2000
- The minimum one-time grant is $75
- A person can recieve no more that $10,000 in grants in a year
Community Assist has a database that tracks donors and grants and which employees were involved in each process. Click below to get an Entity Relation Diagram of the database.
How to Install into Sql Server
- Use Ctrl A to select all the text in the Script.
- Press Ctrl C to copy it to the clipboard.
- Open SQL Server.
- Connect to the database.
- Open a new query window.
- Paste in the script.
- Click the Exclamation point to run the script.
- Refresh the object window to make sure that the database and tables have installed.