FreeStudentProjects
FreeStudentProjectsWeb-based financial Database plan and ER chart is transferred in this article. You can download this undertaking code by the following the connection.
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 | |
| 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 | |
| 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 NOW 🔥4.4 K
14 Comments
Janet
July 5, 2012 - 11:47 PMHello,
How can I download this table. I am not very good in SQL? Any help here?
Admin
July 6, 2012 - 12:57 PMYes. 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 - 11:19 AMI have error from login.php file
that says invalid identifier from below line
$_SESSION[tp] =$type;
Please help this..
Best Regard
uttra
July 6, 2012 - 7:53 PMsir plz send the project in java
K.A
August 29, 2012 - 6:03 PMI’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
October 16, 2012 - 3:45 PMi would like to learn more about oracle how can i do it
admin
October 16, 2012 - 8:33 PMOracle step by step video tutorials:
http://www.youtube.com/watch?v=djKHQeSUuD8
http://www.youtube.com/watch?v=RDxMZcGwrtw
http://www.youtube.com/watch?v=9qNxtHV79u0
http://www.youtube.com/watch?v=8kh1mJg-LCg
http://www.youtube.com/watch?v=0DuBuLkgBXE
namany
October 16, 2012 - 3:46 PMplease you can send the reply on my email
Qutub Khan
October 19, 2012 - 8:53 PMhttp://www.profree4u.blogspot.in
Download more projects for here freee
maureen tusiime
October 13, 2014 - 5:03 PMi would like you to help me think if a project i can design for a bank
Shiva Prasad
October 14, 2014 - 12:21 AMYes front end is already designed.
ghvfsdgvf
November 5, 2015 - 12:52 PMplease attach er diagram
somaliya ha nolato
December 28, 2015 - 12:58 PMwaw good thanks alot
freestudentprojects
December 28, 2015 - 2:51 PMHow you got what you were searching.. Thanks