In this project you will assist a pet rescue charity with managing their donations related data.

computer science

Description

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

 

 

 

 

 

 

2.      Address Table

This is an address lookup table. It has a list of all the known addresses

 

Instruction Files

Related Questions in computer science category