Design and Implementation of School Bus Tracking System

摘要

This project aims to develop a trustful application for parents who let their children with the school bus service.Mostly without awareness and never know the exact location until the children arrive home.Furthermore in an emergency case,sometimes only phone call or instant message is inevitably unprecise and overly slow to get help in time.In a certain case,this application is very useful to track the precise coordinate of the bus and let the user know timely.
　　This paper describes the development of School Bus Tracking System via Android application to provide a precise coordinate of a school bus,and then the data will be updated in the database and then display on the web page.The system consists of three main roles.First,administrator who can add bus details,register students,view bus details,and view feedbacks.Then there is a bus driver who needs to login to the system to provide the coordinate automatically using GPS technology.Finally parent,who can track location of a bus via web application,change password,and write feedback.
　　The system is mainly developed using Visual Studio with.NET framework coded with C＃and JavaScript for web application and ADT with Java language for Android application.Microsoft SQL is used for storing data in the database with REST API as a communication medium to communicate with mobile application.
　　The system's functions in both web and mobile application including login/logout,adding driver,register student,view bus detail,feedback management,tracking location,password management can work flawlessly and efficiently.Furthermore,the web application tracking system has shown an accurate result in which the markers'position on the map are displayed within a kilometer away from the actual location.The implementation's results of the other functions are thus considered effective and reliable.

目录

声明

Acknowledgements

ABSTRACT

Table of Contents

Chapter 1：Introduction

1．1 Motivation

1．2 Objective and Goal

1．3 Literature Review

1．4 Thesis Structure

Chapter 2：Key Technologies

2．2 OOP

2．3 Front-End Technologies

2．3．1 Microsoft．Net Framework

2．3．2 ASP．NET

2．3．3 Microsoft Visual Studio

2．4．1 Microsoft SQL Server

2．4．2 Database

2．4．3 Relational Database

2．4．4 Browser／Server and Client／Server Structure

2．4．5 Structured Query Language(SQL)

2．5 Middleware Technologies

2．5．1 ADO．Net Overview

2．5．2 ADO and ADO．NET

2．5．4 LINQ to SQL

2．6 Overviews of Android

2．6．1 Android Applications

2．6．2 Android OS Architecture

2．6．3 Android SDK

2．6．4 ADT

2．6．5 GPS and Android

2．6．6 Google Maps Android API

2．6．7 REST API

Chapter 3：Requirement Analysis

3．2 Existing system and proposed system

3．2．1 Problems with current existing system

3．2．2 Proposed system

3．3 Functional Requirements

3．4 Non-Functional Requirements

Chapter 4：System Designs and Implementation

4．1 System Architecture design

4．2 Database design

4．2．1 ER diagram

4．2．2 Table design

4．3 School Bus Tracking System Class diagram

4．4 System Function design and Implementation

4．4．1 Login／Register Module

4．4．2 Feedback Management Module

4．4．3 Tracking Location Module

4．4．4 Password Management Module

Chapter 5：Project Testing and Results

5．1 Testing Overview

5．2 Functional Testing

5．3 Non-Functional Testing

5．4 Testing Result

5．4．1 Functional Testing Result

5．4．2 Non-Functional Testing Result

5．5 Interface Running Result

5．5．1 Web application main page

5．5．2 Add Driver page

5．5．3 Register Student page

5．5．4 View Bus Details page

5．5．5 View Feedback page

5．5．6 Tracking Location page

5．5．7 Change Password page

5．5．8 Write Feedback page

5．5．9 Forgot Password page

5．5．10 Mobile application main page

5．5．11 Credits page

5．5．12 Login page

5．5．13 Send Location page

Chapter 6：Conclusion and Future work

6．1 Conclusion

6．2 Future work

References

Curriculum Vitae of Author