+61480015851
Data and System Integration - E-Government Technology - Data integration Demo - Data Cleansing - Report Writing Assessment Answer
Download Solution
Order New Solution
Internal Code: 1AHECE
Data and System Integration Report Writing Assessment Answer
Assignment Task: 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.
- 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. 1000 words
- “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.1 Data Cleansing
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 = 09Task 1.2 Data Merge
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
Task 2 – RESTful Web Service Demo
You are to submit a python script named “office_locator.py”. For tasks 2.1 to 2.2, your script should build a RESTful web service that supports a ‘getoffices’ query from the client browser similar to “/getoffices?serviceid=x”. The server Web Service will return a JSON table with the following fields (attributes): Office, Suburb, Service, Phone, Email, Lat, Lon. Data is to come from the “office_service_locations.csv” you built in task 1.2. Task 2.1 Return offices for service The server will return a table of records (tuples) of offices offering the service ID passed to it.Task 2.2 List of Services
To populate your drop-down list in task 3.1, you will need to return a JSON table of all records from “services.csv” with the following fields (attributes): ServiceID, Service. The server should respond to a “getservices” request.Task 3 Mashup Demo
You are to submit a HTML file “office_map.html” and optionally a CSS file named “office_map.css”.Task 3.1 Form Layout
You are to create an input form that accepts user input for a particular service. The input for the service should be a drop-down list whose items should be created dynamically from a call to getservices from task 2.2. The drop-down list should be accompanied with descriptors and a “Locate Offices” button.Task 3.2 Google Map
Clicking the “Locate Offices” button will trigger a “get offices” web service to retrieve a table of offices matching the service with attributes described in task 2. From this data, you are to display a Google cluster map marking the position of the returned offices. The map should be centered and zoomed to an appropriate level to show all offices in Australia.Task 3.3 Information Window Demographics
Upon clicking a marker bubble on the map, the user will be displayed an information window containing: Contact Name, Suburb, Phone Number, and a clickable email address.This Data and System Integration Assessment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.