Online banking Database design

online banking database

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

Field

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

Table: complaints

Field

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

Field

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

Field

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

Field

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

Table: loan

Field

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

Field

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

Field

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

Field

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

Table: login

Field

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

Field

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

Table: transactions

Field

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

StudentProjects.Live

A collection of source codes that I wrote in VB 6.0, 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.
Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

14 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Janet
Janet
8 years ago

Hello,

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

Admin
8 years ago
Reply to  Janet

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
Qutub Khan Qutbuddin
8 years ago
Reply to  Admin

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

uttra
uttra
8 years ago

sir plz send the project in java

K.A
K.A
8 years ago

I’ve some T-SQL trigger code which I’ve failed to convert to Oracle PL/SQL any help?, send yr reply to wndrmiracle@gmail.com

namany
namany
8 years ago

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

namany
namany
8 years ago

please you can send the reply on my email

Qutub Khan
Qutub Khan
8 years ago

http://www.profree4u.blogspot.in
Download more projects for here freee

maureen tusiime
maureen tusiime
6 years ago

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

Shiva Prasad
6 years ago

Yes front end is already designed.

ghvfsdgvf
ghvfsdgvf
5 years ago

please attach er diagram

somaliya ha nolato
somaliya ha nolato
5 years ago

waw good thanks alot

freestudentprojects
5 years ago

How you got what you were searching.. Thanks