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 donations 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.
Central Donations Repository
The tables created by projectTables.sql script reside in the charity’s Oracle database server as well as the list of the volunteers.
The server is on host named db8.fast.sheridanc.on.ca. Each group is assigned their own database. The credentials to use are:
Server Name: db8.fast.sheridanc.on.ca Port: 22 – SSH, 1521 – Oracle Linux username: userxx Password: Or4cl3S2020 Oracle instance name: Uxx.world Each instance has the following usernames/passwords: • sys/[same as ssh] • system/[same as ssh] • prc/PetRescue • vl1/PetRescue • vl2/PetRescue • vl3/PetRescue • vl4/PetRescue • dml/DataMart
Where the linux username and Oracle instance contain xx – replace it with your group #. Users SYS and SYSTEM are for database administration. PRC is to store the addresses and donors. VL1-VL4 are the accounts for the volunteer leaders. DML is to be used to store that datamart
The list of donors is stored in a comma separated file. A sample named donorsList.csv shows a list that the volunteer group lead sends to the main office. It illustrates the schema and contains only two entries. DONOT USE EITHER OF THOSE ENTRIES IN YOUR SUBMISSION. Each member of the group (presumably a volunteer with a distinct volunteer no) should provide a separate list for their “area” with at least 15 entries. As a result each group will have three (or four) donor lists that contain a minimum of 15 additional entries in the donors list. Make sure that there are both valid and invalid entries. The invalid entries will be rejected and sent back to the respective volunteer coordinator. In total there must be at LEAST 60 distinct names/addresses on at LEAST 3 separate lists.
Master Addresses Table
The address table that the charity maintains is not updated and it often gets out of date. However, there is another department in the organization has an address table that they regularly update and keep current. The table is in SQLServer database and below is the connection information to the server
Server Name: dbr.fast.sheridanc.on.ca Port: 1433 Database name: Integration Schema Name: dbo User Name: DataIntegrator Password: Sher1dan
NOTE: All tasks (1-6) are to be performed using your groups Oracle database.
Proposal (Group Work)
In the past few weeks you learned advanced SQL statements, PL/SQL and Talend Data Integrator. You can use a combination of the three tools to accomplish tasks 1,2, and 4. In order to start the project you need to research these technologies and decide what combination of technologies you will use for every task. You are required to write a one or two pages proposal that must include the below information:
You will be provided with a template for the proposal. The proposal will be submitted by the due date on the Assignment on SLATE.
Report (Group Work)
You must write a one or two pages summary that describes your design for the project in your own words and details your involvement in the project. The summary must have the below 4 sections:
The professor can ask to interview the group if some of the details are not clear about the project implementation. The result of the interview will be considered in the grade
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more