In this project you will assist a pet rescue charity with managing their donations related data.
computer science
Description
DBAS32100 group project Template
Walid Belal
Oct 2019
Introduction
In this project you
will assist a pet rescue charity with managing their donations related data.
The charity organizes an annual donation drive. The city is divided to donation
areas (every donation area is approximately 6 postal codes) and assign a group
of volunteers to every area.
The volunteers will go
door to door in their designated areas in order to collect donations from the
residents. They can collect cash, checks, or credit card payments. At the end
of every week the volunteering group leaders will fill in a list with the
donation record that were collected in their area, and send it to the charity main
office. The staff in the main office will load the list to a central table
after rejecting non-valid entries and then use the data to perform analysis.
Data Sources
Central donations repository
These table resides in
the charity’s oracle database server.
1. Donation table
Every row in this
table is a donation made by a donor. Below is the script that creates donation
table
