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