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
Post navigation
waw good thanks alot
How you got what you were searching.. Thanks
please attach er diagram
i would like you to help me think if a project i can design for a bank
Yes front end is already designed.
http://www.profree4u.blogspot.in
Download more projects for here freee
please you can send the reply on my email
i would like to learn more about oracle how can i do it
Oracle step by step video tutorials:
http://www.youtube.com/watch?v=BVSctBCRPvY
http://www.youtube.com/watch?v=djKHQeSUuD8
http://www.youtube.com/watch?v=GS1ZELDccto
http://www.youtube.com/watch?v=RDxMZcGwrtw
http://www.youtube.com/watch?v=_qBCjLKB_sM
http://www.youtube.com/watch?v=9qNxtHV79u0
http://www.youtube.com/watch?v=R3CknWmJrDA
http://www.youtube.com/watch?v=8kh1mJg-LCg
http://www.youtube.com/watch?v=Ocpg9DyShxU
http://www.youtube.com/watch?v=0DuBuLkgBXE
http://www.youtube.com/watch?v=p8mVOE8i-XY
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]
sir plz send the project in java
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..
I have error from login.php file
that says invalid identifier from below line
$_SESSION[tp] =$type;
Please help this..
Best Regard