Database Management System of a Bank

Project Proposal for a Database
Database for a Bank
Introduction:
This database is created for a bank which can keep track of their customer’s and account holders’ details and transactions.
With the above aim they should be able to have access to the information mention in real time. This will help the management to take decisions and also will make the record and finance staff work more organized.
The bank is experiencing a lot of customer turn out to their various account types. Some do apply for multiple account types at the same time. Sometimes files are being missing, which makes it very difficult to access a particular customer’s record in regarding to personal information, transactions and account details.

Functionalities:
Entities
 Customer
 Account
 User

Properties
Customer:







Name
Customer ID
D.O.B
N.I.C No
Address
Telephone Number

Account:
 Account No
 Account Holder’s Name
 Account Type

Transaction:
 Transaction Type
 Transaction No

User:
 Manager
 Teller

Forms:
 User Login
 Account
 Deposit
 Withdraw
 Customer
 Transaction

Login:
All users are given access rights (usernames and passwords) but they have different levels of authority to the database.
The user has to enter his/her username and password. The password is not visible as it is replaced with asterisks.
There are 2 buttons; Login and Logout

Manager:
A manager can insert, update, view and delete data to and from the database.
Account Form:
The manager can search the account details by entering an account number in the search bar therefore all details of the account will appear; Account Holder’s Name, Account Number, Account Type,
Account Balance and Date Created. The manager can create an account by entering Customer NIC No and clicking the search button; Customer
Name will appear therefore the manager can enter account details and

create an account. The delete and create button