Electronic Cash Controller

ABSTRACT:

This project is mainly developed for the Account Division of a Banking sector to provide better interface of the entire banking transactions. This system is aimed to give a better out look to the user interfaces and to implement all the banking transactions like:

• Supply of Account Information
• New Account Creations
• Deposits
• Withdraws
• Cheque book issues
• Stop payments
• Transfer of accounts
• Report Generations.

This service is open only to savings bank customers and not for current account holders. The customer is privileged to use most of the system only as a viewing phase, the only online transactions the customer can do are Cheque book requisition and fund transfer among his personal accounts. The project ahs been planned to be having the view of distributed architecture, with centralized storage of the database. The application for the storage of the data has been planned. Using the constructs of MS-SQLServer2000 and all the user interfaces have been designed using the ASP.Net technologies. The database connectivity is planned using the “SQL Connection” methodology. The standards of security and data protective mechanism have been given a big choice for proper usage. The application takes care of different modules and their associated reports, which are produced as per the applicable strategies and standards that are put forwarded by the administrative staff.      

The entire project has been developed keeping in view of the distributed client server computing technology, in mind. The specification has been normalized up to 3NF to eliminate all the anomalies that may arise due to the database transaction that are executed by the general users and the organizational administration. The user interfaces are browser specific to give distributed accessibility for the overall system. The internal database has been selected as MS-SQL server 200.The basic constructs of table spaces, clusters and indexes have been exploited to provide higher consistency and reliability for the data storage. The MS-SQL server 200 was a choice as it provides the constructs of high-level reliability and security. The total front end was dominated using the ASP.Net technologies. At all proper levels high care was taken to check that the system manages the data consistency with proper business rules or validations. The database connectivity was planned using the latest “SQL Connection” technology provided by Microsoft Corporation. The authentication and authorization was crosschecked at all the relevant stages. The user level accessibility has been restricted into two zones namely.

PURPOSE OF THE SYSTEM

This project is mainly developed for the Account Division of a Banking sector to provide better interface of the entire banking transactions. This system is aimed to give a better out look to the user interfaces and to implement all the banking transactions like depositing, withdrawing, customer account information, transaction information etc.

PROBLEMS IN THE EXISTING SYSTEM :

·         It is limited to a single system.

·         It is less user-friendly.

·         It is having lots of manual work (Manual system does not mean that you are working with pen and paper, it also include working on spread sheets and other simple software's).

·         The present system is very less secure.

·         It is unable to generate different kinds of report.

·         It doesn’t have the mail and file upload feature.

SOLUTION OF THESE PROBLEMS

The development of the new system contains the following activities, which try to automate the entire process keeping in view of the database integration approach.

·         User friendliness is provided in the application with various controls.

·         The system makes the overall project management much easier and flexible.

·         It can be accessed over the Internet.

·         Various classes have been used to provide file upload and mail features.

·         There is no risk of data mismanagement at any level while the project development is under process.

·         Report generation feature is provided using Crystal Reports to generate different kinds of reports like bar graphs, pie charts and table type charts etc.

It provides high level of security using different protocols like https etc.

STUDY OF THE SYSTEM

In the flexibility of the uses the interface has been developed a graphics concept in mind, associated through a browses interface. The GUI’S at the top level have been categorized as

1. Administrative user interface
2. The operational or generic user interface

The administrative user interface concentrates on the consistent information that is practically, part of the organizational activities and which needs proper authentication for the data collection. The interfaces help the administrations with all the transactional states like Data insertion, Data deletion and Date updation along with the extensive data search capabilities.

The operational or generic user interface helps the users upon the system in transactions through the existing data and required services. The operational user interface also helps the ordinary users in managing their own information helps the ordinary users in managing their own information in a customized manner as per the assisted flexibilities.

Number of Modules

The system after careful analysis has been identified to be presented with the following modules:

The modules involved are:               

·        Account Information

·        New Account Creations

·        Deposits

·        Withdraws

·        Cheque book issues

·        Stop payments

·        Transfer of accounts

·         Report Generations.

HARDWARE SPEDIFICATIONS

HARDWARE REQUIREMENTS:

• PIV 2.8 GHz Processor and Above
• RAM 1GB and Above
• HDD 20 GB Hard Disk Space and Above

SOFTWARE REQUIREMENTS:               

• WINDOWS OS (XP / 2000 / 200 Server / 2003 Server)
• Visual Studio .Net 2008 Enterprise Edition
• Internet Information Server 5.0 (IIS)
• Visual Studio .Net Framework (Minimal for Deployment)                          
• SQL Server 2005 Enterprise Edition