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.
