ATMC Semester 3 ICT705 Data and System Integration Report

This report details the process of data and system integration, starting with disparate CSV files and culminating in a mashup web application. It covers key concepts such as data merging and cleaning, explaining the challenges faced when combining CSV files and recommending the use of a file-based database like SQLite for improved performance and scalability. The report explores RESTful web services, demonstrating their role in querying fire stations based on region and integrating the service with Google Maps and an email service to create a fire station location and contact mashup. The report provides running instructions for the application, emphasizing the need for a Google Maps API key and highlighting potential improvements like adding real-time tracking and user interaction features. The author recommends that the data provider QFES perform the cleaning and merging on their data before giving it out for system integration.