|FACTS for the Data Model for a Loan Management System|
Back to the Conceptual Data Model.
Original Requirements from the User :-
A database for a Loan Management system ... The database collects informartion about Customers who borrow money from a company. Every month the customer must pay at least the capital or the interest rate. Customers :- customer information includes contact details and balance fields, which will tell you how much the customer owes. collector :- collector is the person who gives the money to the customers and collects it later point of time. loangiven :- loan given is actually the loan given by the company to the customers. payment :- payment received by the company. The database will keep track of payments made by customers. Payments can be either the interest or/and capital. Customer (TABLE) Customer_No (primary) Customer_Name Address Balance Collector (TABLE) CollectorID (Primary) CollectorName LoanGiven (TABLE) TransactionID (AutoIncrement id & primary) Customer_No DateLoanGiven AmountGiven InterestRate CollectorID (foreign key - from collector table) Payment (TABLE) ReturnID (AutoIncrement id & primary) Customer_No PaymentDate PAymentMonth CapitalPaid InterestPaid Remarks ----------------------------------- Report Requirements :- Produce a list of those who never pay for a duration. The criteria is balance should be greater than zero. now, i have a sql statement to find those who didn't pay. but, it actually working when the customer paid at least paid once. Suppose, the customer didn't pay at all, that particular record is NOT coming. Also a list of those who never pay a single payment. Currently, I am using Data Report and Data Environment to do all the reports from Visual Basic. So, the output of the report should be single record for each customer as follows : customer_no Customer_Name Address Balance CollectorID CollectorName PaymentDate (the last payment record - if any) PAymentMonth (the last payment record - if any) CapitalPaid (the last payment record - if any) InterestPaid (the last payment record - if any)