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
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