Loan Management System Complete Database Project using MYSQL and Trigger: Back-end Programming 100%
This is a complete database system that stores loan installments of borrowers. The loan repayment information will be seen by the customer when login in this system and sees the loan installments where the customer will be able to see the following information
1.the amount he requested for example USD 1000
2.loan tax deduction ten percent 10% for the amount he requested USD 1000 where it will be USD 100
3.direct charge deduction ten percent 10% for the amount he requested USD 1000 where it will be USD 100
4.the sum of all deductions where it is USD 200
5.The amount of loan he will be given is USD 800
6.The actual loan debt he will owe will be USD 1200
then after taking the loan, the customer will start the installments and if his debt reaches USD 1200 then he will see the loan status on the APP that the loan status is completed
The database will not accept to enter loan repayments for a customer who has already completed the debt
The customer can send complaints or requests through the App and those requests will be received by the employee
CONTENTS
1. how to create table in mysql under command line
2. how to create table relationship under command line
3. how to create table index under command line
4. how to create trigger to compute the loan
5. how to force referential intergrity under command line
6. how to insert data in mysql
7. how to connect to MySQL server under command line
8. how to drop trigger and table
SOURCE-CODES
PHP, DATABASE, TRIGGER,
https://github.com/shamiraty/Loan-man...
PROJECT SOURCE CODE
https://github.com/shamiraty/loan-man...
SAMPLE DEMO APK
https://drive.google.com/file/d/1jfdP...
DATABASE
https://github.com/shamiraty/loan-man...
VIDEO SERIES
episode 0
Android App Project Loan Management System using PHP, MYSQL and Android Studio. Completely Back-end
• Android App Project Loan Management S...
episode 1
Android App: How to create Navigation Drawer and switch between Fragments with default Home Fragment
• Android App: How to create Navigation...
episode 2
Loan Management System Complete Database Project using MYSQL and Trigger: Back-end Programming 100%
• Loan Management System Complete Datab...
episode 3
How to fetch Data from MYSQL using PHP and display data as JSON objects RESTFUL API programming
• How to fetch Data from MYSQL using PH...
episode 4
How to write PHP user Login script using MYSQL for Android or Web Login and send JSON response
• How to write PHP user Login script us...
episode 5
How to link Android App with MYSQL and fetch data using PHP then display those data to Android App
• How to link Android App with MYSQL an...
episode 6
Android App with MYSQL fetch data using PHP then display those data to Android App RecycleView
• Android App with MYSQL fetch data usi...
episode 7
How to Create Android Login Form and Link to MYSQL with Remember Me and Display current User Data
• How to Create Android Login Form and ...
episode 8
How to create Android Option Menu with item switch and Display current Login user in Option Menu
• How to create Android Option Menu wit...
episode 9
How to Create custom Android Dialog and Popup it when User click Switch Button with Dialog Animation
• How to Create custom Android Dialog a...
episode 10
How to Create Android Contact-us Module and send Data to MYSQL by PHP: using Android Fragment
• How to Create Android Contact-us Modu...
episode 11
How to Change Android Launcher icon image and icon color and Change App Name in Android Studio
• How to Change Android Launcher icon i...
episode 12
How to Generate APK of Android App in Android Studio
• How to Generate APK of Android App in...
episode 13
How to Generate Android Signed-in Bundle from Android Studio for publishing App playstore
• How to Generate Android Signed-in Bun...