A bank is a financial institution and a financial intermediary that accepts deposits and channels those deposits into lending activities, either directly by loaning or indirectly through capital markets. A bank is the connection between customers that have capital deficits and customers with capital surpluses.
Due to their influence within a financial system and the economy, banks are highly regulated in most countries. Most banks operate under a system known as fractional reserve banking where they hold only a small reserve of the funds deposited and lend out the rest for profit. They are generally subject to minimum capital requirements which are based on an international set of capital standards, known as the Basel Accords.
Banking in its modern sense evolved in the 14th century in the rich cities of Renaissance Italy but in many ways was a continuation of ideas and concepts of credit and lending that had its roots in the ancient world. In the history of banking, a number of banking dynasties have played a central role over many centuries.
The project entitled “BANK ACCOUNT MANAGEMENT SYSTEM” is an offline system providing detailed information about various aspects of Bank. This system gives details about the Customer Account info, service info, Gold loan info, House loan info, Education loan info, Customer transaction info, Debit or Credit Card info etc.
This project is a user friendly that helps the staff and manager to know about the result according to their requirement. It is an approach to make its information and detail known to anybody.
This system has been implemented using VB.NET2008 as Front End and Microsoft-Access2007 or 2010 as Back End. This Project has following objective to be achieved:-
o To record the information of the entire customer.
o To record the details of customer transaction.
o To record the day to day transaction info.
o The application should be password protected and only the authorized user of the Bank Account Management System can access the data.
The project should be developed such that the necessary functions and performance are achieved within the constraints. The project is developed within latest technology. Through the technology may become obsolete after some period of time, due to the fact that never version of same software supports older versions, the system may still be used. So there are minimal constraints involved with this project. The system has been developed using Java the project is technically feasible for development.
DATABASE DESIGN
A database is an organized mechanism that has the capability of storing information through which a user can retrieve stored information in an effective and efficient manner. The data is the purpose of any database and must be protected.
The database design is a two level process. In the first step, user requirements are gathered together and a database is designed which will meet these requirements as clearly as possible. This step is called Information Level Design and it is taken independent of any individual DBMS.
In the second step, this Information level design is transferred into a design for the specific DBMS that will be used to implement the system in question. This step is called Physical Level Design, concerned with the characteristics of the specific DBMS that will be used. A database design runs parallel with the system design. The organization of the data in the database is aimed to achieve the following two major objectives.
Data Integrity
Data independence
Normalization is the process of decomposing the attributes in an application, which results in a set of tables with very simple structure. The purpose of normalization is to make tables as simple as possible. Normalization is carried out in this system for the following reasons.