Register Now


Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Online banking Database design

Online banking Database design

Online banking Database design and ER diagram is uploaded in this article. You can download this project code by following link..

Database Name: banking

Table: accounts


Type Null Default
acc_type varchar(50) Yes
minbalance varchar(20) Yes

Table: complaints


Type Null Default
slno int(250) Yes
comp_to varchar(20) Yes
comp_from varchar(50) Yes
subject varchar(150) Yes
complaint varchar(750) Yes
comp_date datetime Yes

Table: customer


Type Null Default
custid varchar(200) Yes
first_name varchar(200) Yes
last_name varchar(200) Yes
age varchar(3) Yes
address varchar(200) Yes
country varchar(15) Yes
email varchar(200) Yes
sex varchar(15) Yes
contact_number varchar(200) Yes
acc_number varchar(200) Yes
balance float Yes
acc_type varchar(200) Yes
opendate date Yes

Table: found_tran


Type Null Default
deb_acct_no varchar(50) Yes
cre_acct_no int(20) Yes
date datetime Yes
balance int(50) Yes
deb_amount int(20) Yes

Table: interest


Type Null Default
acc_num int(20) Yes
date date Yes
old_bal float Yes
interest float Yes
tot_bal float Yes

Table: loan


Type Null Default
custid int(20) Yes
loan_type varchar(50) Yes
loan_amount int(20) Yes
duration int(4) Yes
name varchar(25) Yes
address varchar(150) Yes
profession varchar(20) Yes
income int(20) Yes
tele int(25) Yes
email varchar(30) Yes
requestdate date Yes
status varchar(20) Yes

Table: loan_accept


Type Null Default
cust_id int(20) Yes
loan_id int(20) Yes
type varchar(100) Yes
amount int(50) Yes
duration int(20) Yes
start_date date Yes
monthly_inst int(20) Yes

Table: loan_paid


Type Null Default
cust_id int(20) Yes
loan_id int(20) Yes
insta_date date Yes
pay_date date Yes
due_amount int(20) Yes
inst_amount int(20) Yes
balance int(50) Yes
status int(11) Yes

Table: loan_type


Type Null Default
loan_type varchar(100) Yes
duration varchar(20) Yes
loan_amount varchar(50) Yes

Table: login


Type Null Default
user_name varchar(200) Yes 0
user_password varchar(200) Yes 0
user_type varchar(200) Yes 0
question varchar(200) Yes
ans varchar(50) Yes

Table: rejected_information


Type Null Default
cust_id varchar(20) Yes
information varchar(500) Yes

Table: transactions


Type Null Default
tranid varchar(200) Yes
trantype varchar(200) Yes
tranmethod varchar(200) Yes
date timestamp Yes CURRENT_TIMESTAMP
cheque_num varchar(25) Yes
acc_num varchar(200) Yes
amount varchar(200) Yes
current_balance float Yes
remarks varchar(200) Yes
custid varchar(20) Yes
Download Source code:
Download project report

Comments ( 14 )

  1. Hello,

    How can I download this table. I am not very good in SQL? Any help here?

    • Yes. this table is not in sql format.. just copy this table in mysql foler – > data foler..
      Then type localhost/phpmyadmin in browser..

      • Qutub Khan Qutbuddin
        September 18, 2012 at 11:19 AM

        I have error from login.php file
        that says invalid identifier from below line
        $_SESSION[tp] =$type;
        Please help this..
        Best Regard

  2. sir plz send the project in java

  3. I’ve some T-SQL trigger code which I’ve failed to convert to Oracle PL/SQL any help?, send yr reply to [email protected]

  4. i would like to learn more about oracle how can i do it

  5. please you can send the reply on my email

    Download more projects for here freee

  7. i would like you to help me think if a project i can design for a bank

  8. please attach er diagram

  9. waw good thanks alot

Leave a reply

About StudentProjects.Live

A collection of source codes that I wrote in Android, ASP.NET, PHP, C#.NET, VB.NET and JAVA in a course of my career as web developer and software engineer that I would like to share to my fellow programmers. Some of the codes here is not my original work that I found over the Internet and Books while I'm learning how to program. I hope you find my work useful in your learning in programming. Please share my work to other people also who interested to learn the basics of web development and programming. Thank you very much and Happy Productive Programming Everyone.

Follow Me