Sale!
Placeholder

A Data Knowledge Management System for Train Driver Scheduling

10,000 3,000

Topic Description

 ALL listed project topics on our website are complete material from chapter 1-5 which are well supervised and approved by lecturers who are intellectual in their various fields of discipline, documented to assist you with complete, quality and well organized researched materials. which should be use as reference or Guild line...  See frequently asked questions and answeres



Summary
One of the areas of study within the School of Computing is that of scheduling. In order to perform scheduling of train driver shifts, the original train data needs to be manipulated into a format that can be used by scheduling software.
The aim of this project is to, create a system to import the original train data, allow the user to manipulate the data manually, include a number of functions for automatically processing the data and finally to have a system of exporting the data for use by the scheduling software.
This report explains how the project was carried out and how the requirements were met, starting from the point of gathering the requirements through to implementation and testing of the final system.

Contents
1. Introduction …………………………………………………………………………1
1.1 A Background to Scheduling ………………………………………………….. 1
1.2 Current Application in the School of Computing ……………………………..2
1.3 Project Proposal …………………………………………………………………3
2. Analysis ………………………………………………………………………………5
2.1 Background Analysis………………………………………………………….. 5
2.2 User Requirements………………………………………………………………6
2.3 Technology ………………………………………………………………………10
2.4 Methodology ……………………………………………………………………..13
3. Design ……………………………………………………………………………….. 15
3.1 Database Design ……………………………………………………………… 15
3.2 Normalisation …………………………………………………………………….18
3.3 Denormalisation …………………………………………………………………19
3.4 User Interface …………………………………………………………………… 21
4. Implementation ……………………………………………………………………..26
4.1 Database Implementation ………………………………………………………26
4.2 Operational Topics Implementation …………………………………………27
4.2.1 Relief Point Selection ……………………………………………………. 27
4.2.2 Route Section Knowledge Update ………………………………………28
4.2.3 Train Data Manipulation ………………………………………………….29
4.2.4 Route Sections Function …………………………………………………30
4.2.5 Import Data ……………………………………………………………….. 31
4.2.6 Export Data ………………………………………………………………..32
4.2.7 Process Form …………………………………………………………….. 34
4.3 User Manual …………………………………………………………………….. 35
4.4 Installation ………………………………………………………………………..35
5. Testing ………………………………………………………………………………. 37
5.1 The Requirements of testing ……………………………………………..…….37
A Data Knowledge Management System for Train Driver Scheduling Jonathan Fish
___________________________________________________________________
__________________________________________________________________________________
iv
5.2 Test Design ………………………………………………………………………38
5.3 Test Implementation …………………………………………………………….39
6. Evaluation and Conclusion ………………………………………………………41
6.1 Evaluation of the System ……………………………………………………….41
6.2 Areas for Improvement …………………………………………………………42
6.3 Conclusion ………………………………………………………………………. 42
Bibliography ………………………………………………………………………… 44
Appendix A: Reflections on the Project ……………………………………………46
Appendix B: The User Manual …………………………………………………….. 47
Appendix C: Initial Schedule ………………………………………………………..56
Appendix D: Updated Schedule ……………………………………………………57
Appendix E: Example Raw Data …………………………………………………..

GET COMPLETE MATERIAL