BANKING SYSTEM => DATABASE DESIGN

This is a continuation of the project BANKING SYSTEM IN JAVA WITH COMPLETE SOURCE CODE AND REPORT

DATABASE DESIGN

The general theme behind a database is to handle information as an integrasted whole. A database is a collection of interrelated data stored with minimum redundancy to serve many users quickly and effectively. After designing the input and output, the analyst must concentrate on database design or how data should be organized around user requirements. The general objective is to make information access, easy quick, inexpensive and flexible for other users. During database design the following objectives are concerned :-

• Controlled Redundancy
• Easy to learn and use
• More information and low cost
• Accuracy
• Integrity

TABLES USED

Admin Table

Name	Type	Description
Un	Varchar	Stores user name
Pw	Varchar	Stores password

Account Table

Name	Type	Description
Ac_no	Text	Account number
Ps_name	Text	Customer name
Trans_date	Text	Transaction date
Dep_type	Text	Deposit type
Dep_amnt	Number	Deposited Amount
Ac_bal	Number	Account Balance

INPUT FORM DESIGN

Input Design is the process of converting user originated computer based format. Inaccurate input data are the most common cause of errors in data processing .Errors entered by data entry operators can be controlled by input design. The goal of designing input data is to make data entry as easy, logical and free from errors as far as possible. In this system, the input screen are developed according to the user requirements

OUTPUT FORM DESIGN

Computer output is the most important and direct source of information to the user. Efficient, intelligible output design should improve the system relationship with the user and help in decision-making. The outputs provide in the system are the softcopy report available for printing. Printouts should be designed around the output requirement of the user. The output devices to consider depend on the factor such as compatibility of the device with the system, response time requirement and number of copies needed.

BANKING SYSTEM => SYSTEM DESIGN PAGE

This is a continuation of the project BANKING SYSTEM IN JAVA WITH COMPLETE SOURCE CODE AND REPORT

SYSTEM DESIGN

MODULE SPECIFICATION

The software named “Banking System” has six modules;

• Main Module
• Module I Customer
• Module II Customer Report and Settings
• Module III System Properties
• Module IV System Help
• Module V Database Connectivity

1. Main Module

The main module of this project act as the place holder of other sub modules. All other modules are integrated to this common station. This is set as the base frame of this project. This page is featured with links to other sub modules which defines the functionality of the system. All other modules are childs of this parent module. GUI components arranged with great care in order to catch the attention of the user. Menus of this System are characterized with Key Accelerators that helps users to choose an action using short cut keys. The user had the provision to change the look and feel of the system. One can switch to either windows look or to any other Operating System look available. The Java Swings are explored greatly to make the system a perfect one.

2. Module I Customer

The Module I is based mainly on the Customer Data.

This module provides the possibilities of Inserting, Editing, Searching and Deleting the Customer data in the database.

3. Module II Customer Report and Settings

This module defines the functionalities like preparing the statements of customer and defining the criteria by which the interest of the customer to be calculated.

4. Module III System Properties

This module defines the system properties.

5. Module IV System Help

This module defines the Help offered to the users. One can easily understand the functionalities of the system by looking the help provided by the system.

BANKING SYSTEM -> SYSTEM ANALYSIS PAGE

This is a continuation of the project BANKING SYSTEM IN JAVA WITH COMPLETE SOURCE CODE AND REPORT

SYSTEM ANALYSIS

EXISTING SYSTEM:

System Analysis is a detailed study of the various\s operations performed by a system and their relationships within and outside of the system. Here the key question is- What all problems exist in the present system? What must be done to solve the problem? Analysis begins when a user or manager begins a study of the program using existing system.

During analysis, data collected on the various files, decision points and transactions handled by the present system. The commonly used tools in the system are Data Flow Diagram, interviews, etc. Training, experience and common sense are required for collection of relevant information needed to develop the system. The success of the system depends largely on how clearly the problem is defined, thoroughly investigated and properly carried out through the choice of solution. A good analysis model should provide not only the mechanisms of problem understanding but also the frame work of the solution. Thus it should be studied thoroughly by collecting data about the system. Then the proposed system should be analyzed thoroughly in accordance with the needs.

System analysis can be categorized into four parts

• System planning and initial investigation
• Information Gathering
• Applying analysis tools for structured analysis
• Feasibility study
• Cost / Benefit Analysis.

PROPOSED SYSTEM:

Proposed system is a Banking system. According to designate we can create an account, deposit money, withdraw money, search facility, and can view customer details. Our proposed system has the following advantages.

• User friendly Interface
• Fast access to database
• Less error
• Storage Capacity
• Look and Feel Environment

      NEXT => SYSTEM DESIGN

Smart Banking in java , a complete banking solution done in java Btech and Mtech final project with report.

B A N K I N G S Y S T E M

Project Description

The project “Banking System” is developed in Java, which mainly focuses on basic Banking operations. Banking System doesn’t replace any existing software system.

“Banking System” is a windows application written for 32-bit Windows operating systems, designed to help users maintain and organize Banking operation .Banking System is easy to use for both beginners and advanced users. It features a familiar and well thought-out, an attractive user interface, combined with strong searching, insertion and reporting capabilities. The report generation facility of Banking System makes users possible to generate reports’ hard copy.

The software Banking System has four main modules.

• Login Module
• Insertion to Database Module
• Extracting from Database Module
• System Settings Module
• Report Generation module
• System Help Module
  
  
  

  CONTENTS With Detail Links

  
  

  1. Introduction Page

  • Introduction of the project

  2. System Analysis Page
     • Existing System
     • Proposed System
  3. System Design Page
     • Menu Tree
     • Module Specification
     • Tables
     • Input form design
     • Output form design
  4. System Implementation Page
     • About Operating System
     • About the Language
     • System Configuration
  5. Appendix Page
     • Source Code
     • Data Flow Diagram
     • Sample Output
     • Gantt chart
     • Meeting Minutes