22577824835694100121002257774594578STUDENT NAME

22577824835694100121002257774594578STUDENT NAME:
Tebogo J. Nkwe
FAULTY: Faculty of Computing
ASSESSMENT NAME: End Assessment (Project) PAPER CODE: CPN1/G18E
MODULE NAME: Programming using .Net 1 MODULE CODE: C7-PN-11
MONTH: November YEAR: 2018
Tebogo J. Nkwe
FAULTY: Faculty of Computing
ASSESSMENT NAME: End Assessment (Project) PAPER CODE: CPN1/G18E
MODULE NAME: Programming using .Net 1 MODULE CODE: C7-PN-11
MONTH: November YEAR: 2018

Table of Contents
TOC o “1-3” h z u 1.Introduction PAGEREF _Toc529813551 h 22.Task Plan PAGEREF _Toc529813552 h 33.Use case Diagram PAGEREF _Toc529813553 h 43.1Activity diagram PAGEREF _Toc529813554 h 54.Design PAGEREF _Toc529813555 h 64.1Program Structure design PAGEREF _Toc529813556 h 64.2Design- class diagram, ERD, UID PAGEREF _Toc529813557 h 64.3Table relationship diagram from system PAGEREF _Toc529813558 h 74.4Menu design PAGEREF _Toc529813559 h 84.5Form design and its properties PAGEREF _Toc529813560 h 104.6Testing PAGEREF _Toc529813561 h 125.HARDWARE AND SOFTWARE REQUIREMENT PAGEREF _Toc529813562 h 156.Evaluation PAGEREF _Toc529813563 h 167.Conclusion PAGEREF _Toc529813564 h 178.Appendix PAGEREF _Toc529813565 h 189.References PAGEREF _Toc529813566 h 19

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!

order now

IntroductionThis project is based on the ticket booking for the organisation called Travel well coaches, it has 4 buses that travel around 3 countries. The 3 countries being South Africa, Botswana and Lesotho. The problem that they have is that it uses manual hence it is time consuming because the operator will be spending more time in making the reservation and checking in for the many clients. It also uses a lot of resources when it comes to paperwork unlike when it can be reached on the cloud computer. The manual system is costly because the organisation will have to employ a people to operate the manual system. The manual system also uses a lot of resources which is filed paperwork.

The solution to the problem is that instead of the manual system being used the online ticket reservation system will be implemented, which saved a lot of time because the operator and the client do not have to be in one place together to make the reservation. It helps the system administration to easily find any bookings made because all the information will be on the database. The system uses less resources from the paperwork to the human resources employed. The organisation will also be able to save a lot of money when it invests on the online ticket reservation system.

The ticket reservation system designed will be using a windows form connected to a database. The system and the database will be accessed by the clerk and the administration trough login and they each respectively can do different things in manipulating the data. “Electronic ticketing system is the ticketing system which uses self-service technology as a base of application helping the user to book a ticket by themselves” (Ferreira, Porfírio, Cunha, & Silva, 2013).

Task PlanS. No. Task / Activity Planned Date of Completion Actual Date of Completion Responsibility
1. Windows Form Design 18 October 2018 24 October 2018 Tebogo
2. Database (SQL or MYSQL) 20 October 2018 24 October 2018 Tebogo
3. Text file to store audit time stamp 24 October 2018 12 November 2018 Tebogo
4. Use case diagram 25 October 2018 26 October 2018 Tebogo
5. Design 27 October 2018 28 October 2018 Tebogo
6. Program structure design 28 October 2018 01 November 2018 7. Design-class diagram, ERD, UID 02 November 2018 03 November 2018 Tebogo
8. Table relationship diagram from system 04 November 2018 05 November 2018 Tebogo
9. Menu Design 05 November 2018 06 November 2018 Tebogo
10. Form design and its properties 05 November 2018 07 November 2018 Tebogo
11. Testing 06 November 2018 11 November 2018 Tebogo
12. Evaluation 06 November 2018 11 November 2018 Tebogo
13. Documentation 6 November 2018 11 November 2018 Tebogo
Table SEQ Table * ARABIC 1: Task Plan, showing the daily activities of the project
Use case DiagramA use case diagram depicts different operations which are fulfilled by the system. This diagram includes the use case, actors and how they are connected. Use case which is mainly the sequence action that forms a single unit of performance for an actor and actors which basically represents a user who interact with the use case. The figure below shows the system of Travel Well Coaches Bus Reservation has three (3) actors namely Administrator, Clerk, and Client and it also has nine (9) use cases as shown in the below figure:

Figure SEQ Figure * ARABIC 1: Use Case Diagram
Activity diagramThis is an activity diagram and it illustrates the process of bus ticket reservation by the clerk on the system. The below figure shows that the direct step by step from after the clerk has logged into the system until to the last step of ticket printing. The diagram has a start point, two end points after execution, eight action activities and one decision activity. The below figure of the activity diagram depicts the performance done by the clerk:

Figure SEQ Figure * ARABIC 2: Activity Diagram
DesignProgram Structure design
Design- class diagram, ERD, UID
Class Diagram
The Unified Modelling Language (UML) assists one in model systems. The class diagram is one of the more popular types in UML. This helps software developers to generate reports and document software architecture, class diagrams are a type of structure diagram since they describe what must be present in the system being modelled. 
A class diagram below shows the relationships between each object in a Travel Well Coaches Bus Reservation system, including passenger information, staff responsibilities, and bus seats availability. The below figure depicts a useful overview of the Travel Well Coaches Bus Reservation system:

Figure SEQ Figure * ARABIC 3: Class DiagramEntity Relationship Diagram

Figure SEQ Figure * ARABIC 4: Entity Relationship DiagramTable relationship diagram from system
The stable relationships between database tables supports in ensuring data integrity is established, adding to database normalization. The tables created all have Primary key and it is inherited as Foreign Key respectively in other tables, this creates the proper relationship between the recorded data and hence assists in ensuring data accuracy and consistency. The figure below shows the table relationship diagram for the Travel Well Coaches Bus Reservation System:

Figure SEQ Figure * ARABIC 5: Table Relationship DiagramMenu designMenu Item Activities Description
User Management Add New User This Field allows the administrator to add new users, who will be able to have access to the bus reservation system. The user will be assigned with a unique username and password.

Modify User This field allows the administrator to manipulate user details, which update the already existing users on the bus reservation system.

Delete User This Field allows the administrator to manipulate the data, by the form of deleting or removing the user from the system. Which means that user will no longer have access to the bus reservation system
Bus Route Johannesburg to Durban Both the user and the administrator have access to this field, it opens up a form for Bus route showing the available seats of the selected trip.

Johannesburg to Maseru This Field can be accessed by both the user and the administrator, it opens up a form for Bus route and gives information on the availability of seats.

Johannesburg to Gaborone On this field both the user and the administrator they can access it, the field opens up a form for Bus route and gives information on the seats available.

Seats First 4 Expensive seats with window On this field the client can access it and shows all the seats reserved and the bus. This depicts the first four 4 seats as expensive because they are close to the window.

Last seats with window This field can also be accessed by all the users, being the regular user and the administrator. It shows information about the all seats which are close to the windows but less expensive the first four.

Seats without window This field can also be accessed by the user and administrator and it shows the all the seats which are not close to the window and they come at a cheaper prize.
Reports Generation Reserved This field shows information about reserved seats on all the buses from all the routes. It can be accessed by both the user and administrator.

Checked In The checked in field shows the seats which all clients paid for or took the space for the trip. It can be accessed by both the user and administrator.

Cancelled From all the reserved seats, the client can cancel their booking hence this field shows all the reservations which have cancelled and they come at a handsome price as a penalty.
Logs Management User Login This field can only be accessed by the administrator, and it shows all the activities by other users. It shows the logs of all users inclusive of time and location. The user activities shows all the performances done by the user from when they logged in until they logged out from the system.

User Activities User Logout The user and Administrator have access to this field, this item exits or closes the system. The system will prompt the user to provide login information if the user wants to get into the system again.

Close The user and administrator both have access to this field. The close activity allows the user to exit the system and closes the running system, but they will remain still logged in and time out which automatically logs out. When they run the system again it will prompt user credentials for login.

Change Password All have access to this field and it allows change of password, if the user has forgotten their password or feels threatened of security bridges.

Form design and its propertiesForm Design Properties Description
Login Form -UserName-Password
-LogIn Button
-Cancel Button
-Forgot password This is the first form that pops up when running the windows application, it has the username label, username textbox, password label, password textbox and this where the user inserts their credentials. Then there is a login button if the inserted details are correct then user is redirected to the next form. If the inserted details are incorrect an error message shows up. The cancel button exits the windows application. Forgot password opens another form where user will be given a security question to answer it also needs to match with the information on the database.

Home Page Form -Menu
-Search field
-Search Button After the login form the user is redirected to the Home Page form, and the Menu includes menu items which are accessed by different users respective of their role on the system. There is also a search field textbox which allows the user to browse information on the system. It has a search button and it only works if there data inserted on the search field textbox.
Bus Route Form -Menu
-Bus Routes
-Client Details
-Ticket Reservation
-Save Button
Cancel This form includes menu, the dropdown for routes the user just have to provide a key word to search for information and it is extracted from the database into the other fields which relate to the key word. Bus routes are six and the client details includes their full names, id, title, gender, age, and ticket reserve status. The form shows the number of seat that the client has booked. It also shows the reserved ticket as a print preview. The save button only works when all fields in the form are selected and filled with information. The cancel button exits the form and directs the user back to the Home Page form.
Print Ticket Form -Ticket Details
-Print Ticket Button
-Delete Ticket Button The Ticket form shows all the reserved tickets with the routes, seats and buses. The Print Ticket button prints out the selected ticket form the list. The Delete Ticket button deletes the selected reserved ticket.

TestingLogIn Form
The figure below shows the Travel Well Coaches Bus Reservation System LogIn Form, it has the labels Username and Password. The textboxes are username and password where a user is prompt to insert the credentials and they should be correct to redirect them to the next linked form. If the user provides incorrect details an error message is shown, also forgot password allows the user to answer security question the answer should match with database information.

Figure SEQ Figure * ARABIC 6: Login FormHome Page Form
The Home Page Form is the next form that follows after user logs in, the figure below depicts the interface of Travel Well Coaches Bus Reservation System Home form. It includes the Menu with its menu items, the search tool to browse information about the system.

Figure SEQ Figure * ARABIC 7: Home Page FormBus Route Form
The figure below illustrates the Travel Well Coaches Bus Reservation System Bus Route Form, it is inclusive of the Menu with its menu items. Also has the Bus route to select the departure and destination of the passenger, the client details section and lastly the seats to assign the clients.

Figure SEQ Figure * ARABIC 8: Bus Route Form
Hardware and software requirementManufacturer: Hewlett-Packard (HP)
Hardware: Laptop
Model: HP Pavilion G6 Notebook PC
Processor: Intel(R) Core(TM) i3-4030U CPU @ 1.90GHz , 1.90GHz
Hard disk: 500GB
Installed memory (RAM): 4.00 GB
System Type: 64-bit operating system
1-10/100Mbps network card
Operating system: Microsoft Windows 10 Enterprise
Microsoft Office Visio for Enterprise Architect
Microsoft Visual Studio Community
SQL Server Management System

Evaluation1. analyse the process of implementation, focusing on participation of the community
2. analyse the impact or changes that have occurred within beneficiary households and the community
3. identify problems and constraints that have been encountered
4. identify important lessons to be learnt and make recommendations for the implementation of future projects

ConclusionTravel Well Coaches Bus Reservation System was developed to help clerk and passenger interaction in booking bus ticket through a Window Form as a desktop application, and also to help Admin and driver for their daily routine. The bus reservation system was evaluated and through South Africa and the other countries, the results confirm that it is useful to use as it is proficient to help them to perform their transactions easy, direct and successful irrespective of the place and time. Hopefully with the findings of this study it will encourage other bus companies to incorporate a similar system to that of Travel Well Coaches Bus Reservation into the already existing bus services. This will be put into work in order to improve and boost the transportation services so that the human errors are avoided and the passengers or client can be assisted effectively and efficiently. The problem encountered is that the time of documentation submission I could not design Text file to store audit time stamp.

TOC h z c “Figure” Figure 1:Use Case Diagram PAGEREF _Toc529792793 h 4Figure 2: Activity Diagram PAGEREF _Toc529792794 h 5Figure 3: Class Diagram PAGEREF _Toc529792795 h 6Figure 4: Entity Relationship Diagram PAGEREF _Toc529792796 h 7Figure 5: Table Relationship Diagram PAGEREF _Toc529792797 h 8Figure 6: Login Form PAGEREF _Toc529792798 h 8Figure 7: Home Page Form PAGEREF _Toc529792799 h 9Figure 8: Bus Route Form PAGEREF _Toc529792800 h 9
Table TOC h z c “Table”
Table 1: Task Plan, showing the daily activities of the project PAGEREF _Toc529792920 h 3

ReferencesFerreira, J. C., Porfírio, F., Cunha, G., & Silva, J. (2013). Cloud terminals for ticketing systems. SERVICE COMPUTATION 2013 “The Fifth International Conferences on Advanced Service Computing, 7”.

Baraki, P., Kulkarni, Sandhya., Kulkarni, Spurthi., Goggi, A., Keertipriya I ‚Development of an Effective Online Bus Pass Generation System for Transportation Service in Karnataka State? Parashuram Baraki et al, / (IJCSIT) “International Journal of Computer Science and Information Technologies”, Vol. 6 (3) , 2015, 3115-3118(ISSN:097-9646).

Jakubauskas, G. (2010). Improvement of urban passenger transport ticketing systems by deploying intelligent transport systems. “Transport”, 4142(March 2018), 37–41. http://doi.org/10.1080/16484142.2006.9638075Ibrahim, A.K. and Ta’a, A.B. (2015) MOBILE – BASED BUS TICKETING SYSTEM IN IRAQ. Vol.3, No.5, (November 2018), 42-55.

http://www.eajournals.org/wp-content/uploads/Mobile—–Based-Bus-Ticketing-System-In-Iraq.pdfChapple, M. (2018). Database Relationship “Database Relationship are the backbone of all relational databases”. Online Lifewire (November 2018) . https://www.lifewire.com/database-relationships-p2-1019758


I'm Lillian

Would you like to get a custom essay? How about receiving a customized one?

Check it out