Major Project Report Recovered)

A MAJOR PROJECT REPORT ON

SNAKE RUN Submitted in partial fulfillment of the requirement for the award of degree of Bachelor of Technology In “Information Technology” Submitted By: Priya University Roll No: 6170810775 College Roll No: IT/06/6560 Under the Guidance of: Ms. Reena Verma

DEPARTMENT OF INFORMATION TECHNOLOGY ENGINEERING INSTITUTE OF ENGINEERING & TECHNOLOGY-BHADDAL BHADDAL-140108

1

CERTIFICATE This is to certify that major project report entitled “Bank System” being submitted by IT engineering students of 7th semester of IET Bhaddal is a record of students own work carried out by them under this department.

Submitted by: Rachita Mahajan(6170810778) Meenu Chadha(6170810765)

Guide(supervisor): Ms. Reena Verma

2

ACKNOWLEDGEMENT “Any accomplishment requires the effort of many people & this work is no different.” Above all, great acknowledgement is made to MS. Reena Verma who imbibed in us, the knowledge & skills so that we could make this report effective. Without her guidance & support, making of this report would have seemed a very-very difficult task. We wish to express our gratitude to those who’ve contributed to our work, even though anonymously. Since, most of the information in this report is a result of collection from various sources such as books, magazines & Internet. The information gained anonymously has been instrumental in completion of this report. So, again special thanks to these anonymous sources. Last but not the least, we would like to take this opportunity to thank all our teachers who have taught us with all their dedication & effort and have always been a great blessing & support. Once again, thanks to all those who contributed in the successful accomplishment of making of this report.

RACHITA MAHAJAN

3

TABLE OF CONTENTS

S.No. 1. 2. 3. 4. 5. 6. 7.

Chapter Number Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7

Page Number 8-12 13 14-17 18-20 21-46 47 48

4

LIST OF FIGURES

Figure Number

Page Number

Fig 2.1 Fig 4.1 Fig 4.2 Fig 4.3

11 18 19 20

5

LIST OF TABLES

Table

Page Number

Table 6.1

47

6

LIST OF SNAPSHOTS Snapshots 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.8 5.9 5.10 5.12 5.13 5.14 5.15 5.16 5.17 5.18 5.19 5.20 5.21 5.22 5.23 5.24 5.25 5.26

Page Number 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45

7

CHAPTER-1

INTRODUCTION

 Introduction to Front End  Introduction to Back End

8

Introduction to Front End

Software Requirements  JDK 1.6  Jdbc Driver for MySQL Database Server  mysql-connector-java-3.1.12-bin.jar  Database Server  MySQL 5.0  Operating system  Windows2000/XP

Hardware Requirements  RAM: Minimum 256MB  Hard Disk: Minimum 20GB  Intel P4 processor with minimum 2.0Ghz Speed

9

INTRODUCTION TO JAVA  Java is a platform independent, object-oriented, robust, secure and innovative programming language.  It consist of Two Parts  JVM (Java Virtual Machine), which is software component that is used to execute java programs.  Java API (Application Programming Interface) that consist of inbuilt classes that are used in different programs. Sun Microsystems officially describe java with the following attributes. • • • • • • • • • •

Complied and Interpreted Platform Independence and Portable Object Oriented Robust and Secure Distributed Familiar Simple and Strong Distributed Multi-Threaded and Interactive High Performance Dynamic and Extensible

JAVA AND INTERNET Java is strongly associated with internet because of the fact that the first application program written in java was hot java .A web Browser to run applets on Internet .The ability of java applets to hitch a ride on the information has made java a unique programming language for the internet . Infact java is popularly known as programming language for internet.

10

Java Technology: An Application and Runtime Environment ● Java technology applications are typically general-purpose programs that run on any machine where the Java runtime environment (JRE) is installed. ● There are two main deployment environments: 1. The JRE supplied by the Java 2 Software Development Kit (SDK) contains the complete set of class files for all the Java technology packages, which includes basic language classes, GUI component classes, and so on. 2. The other main deployment environment is on your web browser. Most commercial browsers supply a Java technology interpreter and runtime environment. Phases of a Java Program ● The following figure describes the process of compiling and executing a Java program

Java Virtual Machine Model

Source Code

Java Compiler

Byte Code Macintosh Interpreter (JVM)

IBM-PC Interpreter (JVM)

Sun Interpreter (JVM)

Fig 2.1

11

Introduction to Back End

SQL is a standard language for accessing and manipulating databases.

What is SQL? • • •

SQL stands for Structured Query Language SQL lets you access and manipulate databases SQL is an ANSI (American National Standards Institute) standard

What Can SQL do? • • • • • • • • • •

SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL

can can can can can can can can can can

execute queries against a database retrieve data from a database insert records in a database update records in a database delete records from a database create new databases create new tables in a database create stored procedures in a database create views in a database set permissions on tables, procedures, and views

SQL is a Standard - BUT.... Although SQL is an ANSI (American National Standards Institute) standard, there are many different versions of the SQL language. However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

12

CHAPTER-2

INTRODUCTION TO PROJECT The bulk of all money transactions today involve the transfer of bank deposits. Depository institutions, which we normally call banks, are at the very center of our monetary system. Thus a basic knowledge of the banking system is essential to an understanding of how money works. Bank Deposits and Reserves The monetary base is created by the Fed when it buys securities for its own portfolio. Bank deposits themselves are not base money, rather they are claims on base money. A bank must hold reserves of base money in order to meet its depositors' cash withdrawals and to cover the checks written against their accounts. Reserves comprise a bank's vault cash and what it holds on deposit at the Fed, known as Fed funds. The Fed requires banks to maintain reserves of at least 10% of their demand deposits, averaged over successive 14-day periods.

The Movement of Bank Reserves When a depositor writes a check against his account, his bank must surrender that amount in reserves to the payee’s bank for the check to clear. Reserves are constantly moving from one bank to another as checks are written and cleared. At the end of the day, some banks will be short of reserves and others long. Banks redistribute reserves among themselves by trading in the Fed funds market. Those long on reserves will normally lend to those short. The annualized interest rate on interbank loans is known as the Fed funds rate, and varies with supply and demand. The reserve requirement applies only to the bank's demand deposits, not its term or savings deposits. Thus when a bank depositor converts funds in a demand deposit into a term or savings deposit, he frees up the reserves that were held against the demand deposit. The bank can then use those reserves in several ways. For example, it can hold them to back further lending, buy interest-earning Treasury securities, or lend them to other banks in the Fed funds market.

13

CHAPTER-3

MODULES

Modules Included are: 3.1 Customer Module 3.2 Administrator Module 3.3 INFO Module

14

3.1 Customer Module  As the process starts with customer’s account. In the above data flow diagram  Customer initiates transactions and update his account,receives statements and write checks and debit his account.  Thus this whole module deals with the customer only .

15

3.2 Administrator Module  Administrator deposit funds,view balance of the customer and records all the transactions made by the customer.  Bank transfer the funds of a customer and helps to change the pin to a customer.  This whole module deals with the administrator only.

16

3.3

INFO Module  The module provides the required information to manage the bank system in the efficient manner.  The thee main parts of information module are : • data collection • data storage • information retrieval.

17

CHAPTER-4

DETAILED ANALYSIS OF EVERY MODULE

Customer Module:

Fig 3.1 Above data flow diagram shows the brief description of Customer Module As the process starts with customer’s account. In the above data flow diagram ,Customer initiates transactions and update his account,receives statements and write checks and debit his account. Thus this whole module deals with the customer only .

18

Administrator Module:

Fig 3.2 Above data flow diagram shows the work of administrator in the bank. Administrator deposit funds,view balance of the customer and records all the transactions made by the customer. Bank transfer the funds of a customer and helps to change the pin to a customer. This whole module deals with the administrator only.

19

INFO module:

Fig 3.3 This data flow diagram gives the brief description of the INFO module. The module provides the required information to manage the bank system in the efficient manner. The thee main parts of information module are : • data collection • data storage • information retrieval.

20

CHAPTER-5 SCREENSHOTS

5.1 OpenNewAccount:

A customer has to create a new account in a bank before any transaction takes place. The shortcut key ctrl+N will help the customer to open a new account.

21

5.2 Save Account:

This will save the new account of the customer.

22

5.3 Deposit Money:

With the help of this amount can be deposited.

23

5.4 Withdraw Money:

This will help to withdraw money from bank.

24

5.5 Delete AccountHolder:

This will delete the customer’s account.

25

5.6 Search Customer[By No.]:

This will search the customer’s account.

26

5.7 Search Customer[By Name]:

This will search the customer’s account by name.

27

5.8 View AccountHolders(one by one):

This will view the customer’s account.

28

5.9 View AllAccountHolders:

29

5.10 Change Background Color:

30

5.11 Choose Background Color:

31

5.12 Change Layout Style:

5.13Change Layout Style(Windows): 32

5.14 ApplyTheme: 33

5.15 Close Active Window:

34

5.16 Close AllWindows…:

35

36

5.17 Help Contents:

5.18 Help on Shortcuts: 37

5.19Print Customer Balance:

38

39

5.20 PrintRecord:

5.21 Print: 40

5.22 Minimize: 41

5.23 Minimized form:

42

5.24 Quit BankSystem?:

43

5.25 Exit:

44

5.26 On RightClick:

45

46

CHAPTER-6

DATABASE TABLE

Table 6.1: Account No.

Customer Name Opening Date

Bank Balance

5 66 888 222 4545 3423 4

aman Raja Rani Amit Rrfds Sdfsefd Johny

5000 7000 200 80000 24598557 4534 4000

January,5,2000 January,8,2000 April,1,2007 May,1,2009 January,1,2000 January,1,2000 January,4,2000

47

CONCLUSION AND SUMMARY

The bulk of all money transactions today involve the transfer of bank deposits. Depository institutions, which we normally call banks, are at the very center of our monetary system. Thus a basic knowledge of the banking system is essential to an understanding of how money works. With the help of bank system a customer can create,delete,update his account. He can also deposit and withdraw money as per the need. This will be possible only with the efficient bank system.

48