Bank management system DEVELOPED BY Nikhil K Phalke ROLL NO: 19BIT018 EXAM NO: GUDIED BY : Mona dave TYBsc (CA&IT) (SEM 6 th )
Project Title Bank management system Front-End Tool Visual basic and sql server Back-End Tool SQL Server 2008 Project Development By Nikhil Phalke Project Submitted To Shree D.N Institute Of Computer Applications, Anand Duration December 2021 to march 2022 Project Guide Mona Dave PROJECT PROFILE
Definition to System Based on the information of Bank management. Automate the manual work of generating reports, and forms. Helps user to retrieve the information of their particular bank account ,deposit , withdrawl ,credit as well guiding them to open new bank account. To automate the entry and access of data, making it easier, safe, secure and faster.
PROPOSED SYSTEM To improve the efficiency of Banking To eliminate the time consuming documentation for all purpose To keep the track of the cash available in bank tresury . Customer records were stored inefficiently, and are easily retrievable. Better Customer satisfaction The opening of new bank account ,to deposit ,to withdrawl ,to check credit and for applying for loan in short time is easy
An Existing System The existing system is manual. The existing system maintains all the records like Account holder ,account type,new account , deposit , withdrawl ,credit and loan The manual system is very slow and time consuming . The existing system contains large numbers of errors due to manual system. So, we decide to make a computerized system, which is less consuming and error pane.
Hardware requirements of the system 2.5GHz Dual processor that are each 3 GHz or faster. 1 GB RAM Disk NTFS file system-formatted partition with of 3GB free space. 60 GB Hard-Disk. 4x Compact Disc drive or faster. Monitor. [ 640 x 480 Display ] Keyboard. Mouse.
Software Requirement Front End :- Vb.net. Back End :- SQL Server. Operating System:-Microsoft Window XP
Advantage of System Offers better service in terms of accuracy and efficiency. Action and editing tools are their. Information of customer and employe are easily available Provides accurate information. Easily checks for the validation of data. Removal of Data Redundancy. Data Consistency. Data Security. Report retrieving is easy.
DATA FLOW DIAGRAM(DFD)
Zero level DFD :-
First LEVEL DFD
First Level DFD
Er diagram for bank database scheme
Data Dictionary 1.”Account info” Table Description: It contains the Registration Detail of the user. :-
2.“Branch Info” table
Loan info table
Splash Form
Login form
MDI Form
Account opening form
Deposit form
Withdraw form
Loan form
Conclusion The data of the items and also other Bank activities will be kept in a structured manner. The retrieval, updating, addition and the deletion of the data will be much easier. Retrieval of the old information for the Bank use will be much quicker. The documentation of the procedures will be well-designed and well-formatted. The reports generated by the computerized system will be presentable and also understandable. The security of the important data will be provided in an efficient manner. The change in one particular document will also be reflected to other related document. User will understand the system. He won’t have doubts about working of the system.