Railway Management SystemIN DATABASE System

sdDZFRWEFDXCGHMER;DMXFLKD MAZ

1. Railway Management System Team 10 -Ahmed Walid - Aly Abd El Haleem -Abd El Rahman Tarek -Mohamed Abu Bakr

2. Agenda Project description. Types of Application Users. Provided Functionalities for each User.

3. 1-Project description This is a railway management system that simulate a real life railway system of an entire country The system consists of multiple stations with known-length-routes connecting them. All the data of the stations, trains, passengers, subscription, tickets and employees are stored in our 17-table-database.

4. 1-Project description The windows application enables the employees to do their jobs easily as described in users functionalities section. Note: not all employees have access to the application.

5. 2-Types of Application Users Admin Manager Station Manager Booking clerk

6. Provided Functionalities for each User Admin He has the functionalities of all the users in addition to the ability to add and remove other admins.

7. Provided Functionalities for each User Manager Hire / dismiss a Station Manager. Buy / Sell trains. Monitor the state of the trains. Open a new station. Change salaries of station managers.

8. Provided Functionalities for each User Manager Add/remove a Subscription. Manage coach and repair yards. Update Station data. Review employees’ information. Review passengers’ information. Review the trips.

9. Provided Functionalities for each User Station Manager Hire / dismiss an employee. Update Station data. Review employees’ data. Manage coach and repair yards. Determine the price of the ticket. Manage Trips. Change salaries of employees.

10. Provided Functionalities for each User Booking Clerk Checks the availability of tickets. View the information of trips. Book a seat. Cancel a Ticket. Edit passenger data. Edit Ticket data Manage passenger subscription

11. Provided Functionalities for each User Every user can see statistics designed specifically for him.