An online banking database design is the process of creating a database to help manage banking operations. The database typically includes features such as customer accounts, transactions, payment processing, and fraud detection. It is important to properly design the database to ensure that it is secure and can handle large volumes of data. The database should also be indexed so that queries can be executed quickly. Additionally, the database should be designed in a way that allows for scalability and flexibility. 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