ABSTRACT:-
The main aim of this project is it gives information about the Functioning of Databases in
Banking System.
Usually all persons want money for personal and commercial purposes. Banks
are the oldest lending institutions in Indian scenario. They are providing all
facilities to all citizens for their own purposes by their terms. To survive in this
modern market every bank implements so many new
innovativeideas,strategies,and advanced technologies. For that they give each
and every minute detail about their institution and projects to Public.
Bank are very important in our daily life.
STATEMENT OF PROBLEM:-
A bank's activities in all its divisions can basically be simplified as follows: it
transfers money and information, and in doing so transforms money, maturities
and risks. In the rest of my speech, I intend to use the example of four lines of a
bank's business to examine how it does this, the value added it createS the risks
it encounters and the restrictions to which it is subject: (1) lending and deposit
business, (2) securities issuing, (3) asset management and (4) foreign exchange
trading.
FUNCTION REQUIREMENTS OF BANKING SYSTEM:-
All the customers of the bank have a unique account number.
Customers at least must have 500, account balance.
Such person is eligible for attain loan whose have account in bank.
Carts (ATM or Debt) are also issued to customer according to their eligibility.
All cards holds unique card and pin numbers.
Essential entities' and attributes whose exist for storing data of bank accounts
are shown below in the form of table.
CUSTOMER
Costumer_id
Costumer _Name
Account_no
Address
Age
Gender
Branch
ACCINFO
Account_Number
Account _Type
Balance
Account_Branch
LOANINFO
Loan_Type
Loan_Amount
Account_No
Interest
CARDINFO
Card_Number
Card_Type
Account_no
EMPLOYEEINFO
Employee_id
Employee_Name
Branch
Status
Salary
Address
Phoon_no
Excepted E-R diagram:
PROJECT PERPOSAL
Subject:
Data Base Management System
Topic:
Bank Management System
Submitted To:-
[Link] Shahzaib
By Group Members:-
[Link] Raza Sp13-BSCS-B9-B-97
Muhammad Sufyan Sp13-BSCS-B9-B-76
Junaid Saeed Sp13-BSCS-B9-B-69
Anusha khan Sp13-BSCS-B9-B-81
Aqsa Ramzan Sp13-BSCS-B9-B-72
Submitted on:
15-04-2014