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 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.

Data Sources

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

Donation List

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

Tasks

1. Refresh the address table in the group’s Oracle database with the addresses in the master table. You will need to transform some data types and generate a sequential id for the address. Note that the:
   • ids of some addresses will be used as foreign key in donation table so your solution should accommodate this fact.
   • the master table does not contain postal codes so your solution should accommodate this fact
2. Create a process that loads the donations list to the central donations table: In this task you will load each donor file into the central repository (Oracle tables). You need to make sure that only the donations with valid addresses are inserted into the table. Donation records with erroneous addresses must be rejected. Also make sure to reject the donations that have nulls for the mandatory columns in your database (e.g. NOT NULL columns). You must generate a csv file corresponding to the volunteer group leaders with the records that were rejected in their area.
3. Create a star schema for the donations. The grain of the schema should be the combination of day, address, and volunteer containing the sum and average amounts
4. Create a process to load the data to the star schema from the central donation repository
5. Create views that shows
   • The average and sum of the donation by day, month, year
   • The average and sum of the donations by address, postal code
   • The average and sum of the donations by volunteer and volunteer group leader
6. Basic Security
   • Create a user named DMLUser and give the user permissions to implement all DML on address, donation, and volunteer tables
   • Create a user named Dashboard and give the user read permissions on the views

NOTE: All tasks (1-6) are to be performed using your groups Oracle database.

Deliverables

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:

1. Who is responsible for each task? The work should be assigned in a balanced manner between the group members.
2. Proposed due date for every task.
3. Dependencies between the tasks.
4. How do you plan to complete tasks 1,2 and 4. in this part you need to describe the process that you intend to follow in order to compete the tasks.

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)

1. Create a Microsoft word report documenting the processes. The report must include 6 sections. Each of the section will be describing one of the 6 tasks. You must describe the processes in details. Use embedded screenshot and text descriptions in the document to illustrate the ETL processes. The screenshots must be proportional to the page and yet must be clear. Restrict the screen shots only to the areas that are relevant to the description.
2. An export for your TOS project as a zipped file. Use the “Export Projects” button on the menu bar to make an Archive File to export resources to an archive file on your local file system. Make the file name gggggg_ssssss.zip where gggggg is your group (e.g. group1) and ssssss is the section number of this course. Include the project component and each of its routines (e.g. GROUPPROJECT and GROUPPROJECT_ROUTINES)
3. A zip file containing all the donation lists files (.csv) and their companion reject lists (also .csv)
4. A zip file containing all SQL and/or PL/SQL code used for the Oracle servers

Individual 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:

1. A brief description of your group’s solution to the project, what are the differences between your final solution and the proposal if any, and why did not you partially follow your proposal
2. Your contribution to the project. You will get the full grade on this item if your contribution is proportionate to the other group members and if it is well described. You will get a bonus grade if your contribution is greater that the other members in the group
3. State the difficulties that you faced in the project
4. Suggest improvements to the pet rescue operation data collection process. The suggestions must be related to the scope of this project.

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

Who is a stakeholder and what activities do this person perform?

Text

Title: Managing Project Stakeholders 

ISBN: 9781118504277 

Authors: Tres Roeder 

Publisher: John Wiley & Sons 

Publication Date: 2013-04-22

A completely secure environment is an unusable environment for users. 

How can security work in an atmosphere that mandates usability over safeguards?   

Why is it important to use publicly known algorithms instead of proprietary algorithms that are unknown? 

Review some common websites to find areas that should use HTTPS instead of HTTP. 

Document why they should be encrypted and not transmitted in plain text. 

Define your values as they relate to cryptography. Is the use of cryptography always ethical?  When would the use of cryptography not be ethical?

300+ words with citations. 

No-plag. 

1.Go to teradatauniversitynetwork.com and find the paper titled “Data Warehousing supports corporate Strategy at First American Corporation” (by Watson, Wixom, and Goodhue). Read the paper and answer the  following questions:
(a) What were the drivers for DW/BI project in the company?

(b) What Strategic advantages were realized?

(c) What operational and tactical advantages were achieved?

(d) What were the critical success factors for the implementation?

2. Go to http://analytics-magazine.org/issues/digital-editions and find the jamuary/february 202 edition titled “Special Issue: The future of Healthcare” Read the article “Predictive Analytics- Saving lives and lowering medical bills” Answer the following questions:
(a) what problem is being addressed by applying predictive analytics?

3. Find information about IBM watsons activities in the healthcare field.write report.( (limit to one page of analysis for this part 3 question )

Total of 2-3 pages

be sure to include an APA cover page and include at least two APA formatted references (and APA in-text citations)

File submission: MS Word 2016 practical exam: Word processing document creation

Objective of the activity

Typing in a word processor is not enough. Knowing the functions of the word processor and the proper use of them, result in a document with a professional appearance, which invites and facilitates its reading. In this activity, each student will develop a document in a word processor using the functions that are requested.

Instructions

The academic goal of this task is to meet three of the most important contemporary personalities in the evolution of computers. The names that you will see below may be known:

Steve Jobs

Michael Dell

Bill gates

Additionally, it will include a fourth person, whose career makes him worthy of being on a par with the characters mentioned above.

To carry out this activity, you must carry out research using resources such as databases or the Internet. The sources of information consulted must be reliable sources (not monographs.com, Wikipedia.org, good homework, lazy corner… among others).

You will deliver an electronic document correctly written in your own words in which you will summarize the most important aspects of these personalities: origin, something from their childhood; education, his foray into the world of computers and his most important contribution or contributions. The document should not be as short as half a page, but it is not intended to be long either. One page is expected for each individual investigated.

Download the document for the activity:

What are we going to do?

After having collected, analyzed and paraphrased the information, you will deliver one (1) document created with a word processor, following the outline for the written work. The work must have:

Cover page

Table of Contents (using the Table of Contents function of the Reference tab)

Introduction

Personalities in the Evolution of Computers (present in alphabetical order by last name)

Michael Dell

Bill gates

Steve Jobs

_________________ (Name of the character identified by the student)

conclusion

References

Index

Appendix (Each appendix on one page, arranged alphabetically by last name). In this section you can include a photo of the character

Appendix A – Michael Dell

Appendix B – Bill Gates

Appendix C – Steve Jobs

Appendix D – Character name identified by the student.

Through their work, the student will be able to practice the following skills:

Create and save documents in word

give attributes such as:

Blacken and italic

Align vertically

Align horizontally

Applying the styles (Style)

do

“Page break (page breaks)

Page numbering

“Header (headers) & footer” (footer)

Spacing (line spacing)

single and double

“Before & after”

Table of Contents (using the Table of Contents function)

Index (using the Index function)

How are we going to do the job?

Study the resources in the unit.

Search for information from reliable sources.

In a word processor document, write your work. It is important that you summarize and use paraphrasing techniques when writing your work.

Structure your work so that it complies with the parts to be developed. See the Outline document for written work.

Perform the required functions and apply the required attributes.

Save the document as Personalities in the Evolution of Computers_your name. For example, Personalities in the evolution of computers_Maria Olivero

Upload your work to the platform. The activity allows you to upload only one file.

If in doubt about how to do the job, review the tutorials and simulations

The activity is individual. The works will be submitted to the tool to detect similarity of content (now Urkund).

Deliverable

Each student must submit a document written in a word processor. The activity is individual. The work must be delivered on time, without spelling or grammatical errors. The works will be submitted to the tool to detect similarity of contents (now Urkund)

The work must have the following parts:

Cover page

Table of Contents

Introduction (at least three paragraphs of five sentences each)

Personalities in the Evolution of Computers (present in alphabetical order by last name)

Michael Dell

Bill gates

Steve Jobs

_________________ (Name of the character identified by the student)

Conclusion (at least three paragraphs of five sentences each)

References

Index

Appendix (Appendix divider page)

Each appendix on one page, arranged alphabetically by last name). In this section you can include a photo of the character

Appendix A – Steve Jobs

Appendix B – Michael Dell

Appendix C – Bill Gates

Appendix D – Character name identified by the student.

Basic review resources

Beskeen / Cram Duffy / Friedrichsen / Reding. (2017). Microsoft Office 365: Office 2016. Boston: Cengage Learning.

Microsoft. (2018). Word for Windows Training. Retrieved from https://support.office.com/es-es/article/word-for-windows-training-7bcd85e6-2c3d-4c3c-a2a5-5ed8847eae73 (Links to an external site.)

Shelly Cashman Series (2017). Microsoft Office 365: Office 2016 Advanced. Boston: Cengage Learning.

Ortiz, I. (2019). Outline for written work.