Assignment – ICT705 Data and System Integration
Details: ICT705
Data and System Integration
Task 2
Semester 1, 2019
ICT705 Data and System Integration Assignment 2
Page 2 of 8
Assessment and Submission Details
Marks: 40% of the Total Assessment for the Course
Due Date: 11:59pm Friday, Week 12
Submit your assignment to Blackboard Task 2. Please follow the submission instructions in
The assignment will be marked out of a total of 100 marks and forms 40% of the total
assessment for the course. ALL assignments will be checked for plagiarism by SafeAssign
system provided by Blackboard automatically.
Refer to your Course Outline or the Course Web Site for a copy of the “Student Misconduct,
Plagiarism and Collusion” guidelines.
Late submission will be penalised according to the policy in the course outline. Please note
Saturday and Sunday are included in the count of days late.
Requests for an extension to an assignment MUST be made to the course coordinator prior to
the date of submission and requests made on the day of submission or after the submission
date will only be considered in exceptional circumstances. Assignment submission extensions
will only be made using the official University guidelines.
ICT705 Data and System Integration Assignment 2
Page 3 of 8
Background: E-Government Technology
After evaluating various platforms, the government finally decided to adopt a Service
Oriented Architecture (SOA) for its future IT infrastructure. They were impressed with your
template-based Reference Architecture approach set out in your Task 1 Report and have
accepted your recommendations regarding:
• Computing and storage infrastructure design,
• Application / service integration, and
• Information integration.
However, they would like to gain a deeper understanding of the technologies behind your
recommendation and have asked for a small specific demonstration of these technologies
along with a brief explanation of the concepts and principles of how it works.
Assignment Task
This assignment consists of two deliverables, being:
• Demonstration code (50%). All code relating to this assignment should be contained within a
folder named: Task 2 – Your Name – Student Number, the folder is then to be zipped and
uploaded to blackboard.
• A report (50%). The report must be uploaded separately.
Part 1 – Demonstration Code (50%)
Important Note: For ease of demonstration, your code must be self-contained. In addition to
using Standards based HTML and Python, PETL, Bottle and Parser are the only additional
frameworks you should need. If you use others they must be provided and not require
To demonstrate your code, you have been provided with four data sources compiled with
fictitious sample data. These are:
• “Offices.csv” contains the information about the government offices,
• “Office_Locations.csv” contains the location coordinates for each office,
• “Services.xml” contains a list of government office services, and
• “Office_Services.csv” contains a list of offices and the services they offer.
Task 1 – Data integration demo.
You are to submit a python script named “data_integration.py” which first clean the data then
merge it into one CSV output file named “office_service_locations.csv”.
ICT705 Data and System Integration Assignment 2
Page 4 of 8
Task 1.1 Data Cleansing (10 marks)
Clean the data in the phone number field in “Offices.csv” to ensure all phone numbers are in
the same format:
(+international_code) regional_code phone_number
That is, all phone numbers should have the international code for Australia “(+61)”, followed
by a space, followed by the regional code in two digits, followed by a space, followed by 8
digits of the local phone number. For example, the Brisbane office should be formatted to:
(+61) 07 36728709
Whilst regional codes do not always adhere to state boundaries, you may apply the
following regional codes for each state:
NSW = 02
VIC = 03
QLD = 07
SA = 09
Task 1.2 Data Merge (10 marks)
Merge the data from all four data sources, and generate output file
“office_service_locations.csv” with the following fields (attributes):
• OfficeServicesID – a unique field identifying each record from Office_Services
• OfficeID – a foreign key linking to Services from Office_Services
• Service – the ServiceName from Services
• OfficeID – a foreign key linking to offices and locations
• Office – the “Contact Name” from offices
• Suburb – the “Suburb” from offices
• Phone – the cleaned “Phone Number” data from offices
• Email – the “Email” address from offices
• Lat – from Office_Locations
• Lon – from Office_Locations

Private and Confidential

Yours all information is private and confidential; it is not shared with any other party. So, no one will know that you have taken help for your Academic paper from us.

This essay is written by:

Prof. Amanda Verified writer

Finished papers: 435

Proficient in:

English, History, Business and Entrepreneurship, Nursing, Psychology, Management

You can get writing help to write an essay on these topics
100% plagiarism-free

Hire This Writer
© 2017 theacademicessays. All Rights Reserved. Design & Developed by theacademicessays.

Ask Your Homework Today!

We have over 1000 academic writers ready and waiting to help you achieve academic success


Hello! Need help with your assignments?