22-01-2013, 01:07 PM
PROJECT ON RAILWAY RESERVATION SYSTEM
1RAILWAY.pptx (Size: 352.62 KB / Downloads: 120)
INTRODUCTION OF THE PROJECT
The pilot project of CRS was launched on Nov 1985, over Northen Railway with the installation of the Integrated Multiple Train Passenger Reservation System (IMPRESS), an online transaction processing system developed by the Indian Railways in association with Computer Maintenance Corporation (CMC) Ltd., at New Delhi.
Railway Reservation System is a prominent example of how Information Technology can be leveraged to provide transparency and convenience to users on a very large scale and is a pioneering e-governance initiative in the country. However, an IT enabled system on such a vast scale, also requires rigorous controls to sustain operations and to ensure that it is being run as intended, and complying with all the relevant rules and regulations. The system was found to have a few major design deficiencies and the areas of concern were related to system based and manual controls.
These leave the system open to the risk of misuse adversely affecting the seat/berth availability to general passengers. The system also had design deficiencies which caused inconvenience to the passengers. Moreover, crucial areas covering security of the system and data, system and process documentation, database management, change management and user privilege management processes were either inadequate or poorly addressed. Absence of a structured disaster management policy coupled with associated work practices exposes the system to serious risk of disruption, in case of a physical disaster.
OBJECTIVE OF THE PROJECT
The review of CRS (CONCERT) was conducted with a view to assessing
whether:
• the acquisition and maintenance of hardware, communication network
and software including system design were adequate and effective;
• the general controls were adequate and system was operating in an
adequately controlled environment;
• the application controls were adequate and the system was in compliance with rules and adequately secured from possibilities of fraud;
• there was an effective mechanism to ensure most economic usage of
available resources; and
• the accounting arrangements and control mechanism for credit cardtransactions were adequate.
FRONT END JAVA:
Java is a general-purpose, object-oriented programming language developed by Sun Microsystems of USA in 1991.
Java (with a capital J) is a high-level, third generation programming language, like C, Fortran, Smalltalk, Perl, and many others. Compared to other programming languages, Java is most similar to C. Knowing how to program in C or, better yet, C++, will certainly help to learn Java more quickly, but you don't need to know C to learn Java. Unlike C++ Java is not a superset of C. A Java compiler won't compile C code, and most large C programs need to be changed substantially before they can become Java programs.
What's most special about Java in relation to other programming languages is that it lets you write special programs called applets that can be downloaded from the Internet and played safely within a web browser. Java solves this problem by severely restricting what an applet can do. A Java applet cannot write to your hard disk without your permission. It cannot write to arbitrary addresses in memory and thereby introduce a virus into your computer. It should not crash your system.
BACK END MS-ACCESS:
Microsoft Access is a computer application used to create and manage computer-based databases on desktop computers and/or on connected computers (a network). Microsoft Access can be used for personal information management (PIM), in a small business to organize and manage data, or in an enterprise to communicate with servers.
Microsoft Access is a software package for database management. It comes as a component of the MS-Office package. Access is an easy to use with full-featured database a development application.
Microsoft Access is a 32-bit relational database management system (RDBMS). It allows for the creation, organization and manipulation of large quantities of data. MS Access allows managing all information from a single database file known as .mdb file (a file with the mdb extension). A database is a collection of data and related to a particular purpose.
MS Access is an advanced tool used to store data in table forms. Basically, this is used to store data and as a back-end in many projects.
SCOPE
The scope of project included evaluation of the application and was primarily concerned with the transactions related to booking of tickets from the terminals operated by the railway personnel.
The records maintained in the database of the railways reservation centre were also reviewed. Discussions were held with the database users to gain understanding regarding the various functional aspects of the system.