Reference no: EM132519480

ICT705 Data and System Integration Assignment - University of the Sunshine Coast, Australia

Details - Task consists of a demo code package and a technical report for the integration plan. Submit your work in two parts. Part 1 will include your report (a .docx file) and Part 2 is a zip file, which contains the code files (.zip file).

Case Study - Overseas Shipping Logistics Ltd

Assignment tasks - This assignment consists of two deliverables:

1. Demonstration code - demonstrating the principles of data merging, RESTful Web Services and Mashups.

2. Integration report - explaining the principles of data merging, RESTful Web Services and Mashups and applying them to the case study organization.

Deliverable 1 - Demo code

Instructions: Before importing the COVID-19 data into Python you are required to:

i. Choose 15 countries from the "owid-covid-data.csv" dataset you think would be applicable to the case study,

ii. Retain the most current day's statistics for each of these 15 countries,

iii. Add 2 or 3 extra columns to your dataset. These columns will contain other 2 or 3 other interesting statistics of your choosing for each of your selected countries (you will need to do some quick research on the countries you choose to include).

iv. Populate these extra columns with the statistics you research for each country.

v. Save this new dataset into a new .csv file which you can import into Python.

Create a Python scrip file with the name "data_merger.py"

This Python script will use the Python petl framework to:

i. Import your new CSV and "Country_location.xml" files into Python.

ii. Merge the country geolocation data from the XML file with the COVID-19 data, and

iii. Export the merged data as a .csv file named "covid_countries.csv"

Deliverable 2 - Integration Report

In addition to the above demo code you are required to include a Report explaining the key concepts around the demo design and implementation.

Your report should follow the following template:

Executive Summary

Table of Contents

Table of Figures (if needed)

Table of Tables (if needed)

1.0 Introduction

2.0 Service Oriented Architecture (SOA)

3.0 Key System Concepts

3.1 Data Cleaning & Merging

3.2 RESTful Web Services

3.3 Mashup Design

4.0 Demo Running Instructions

5.0 Conclusion & Recommendations

Reference List

Appendices (if needed)

Please address the following in your report:

Outline the theory and technologies under each of the headings.

Explain how these technologies can be applied by OSL. Outline the difficulties, advantages and disadvantages to OSL. Give examples in addition to the COVID-19 application,

Explain how to run your code and the principles behind each step - you may use screenshots of Mashups, etc. if you wish,

Reflect on your journey as you developed the demonstration - the problems you faced, how you researched and found answers.

Attachment:- Data and System Integration Assignment File.rar