Originally Posted by
timothybard
This should give you a nudge in the right direction:
Client: ID (PK)
Application: ID (PK), Client ID (FK), Machine, Finance Company
Finance Company: ID (PK)
Loan: ID (PK), Application ID (FK), Approved Loan Amount, Minimum Payment
Machine: ID (PK)
Machine Tracking: ID (PK), Machine ID (FK), Ordered, received, delevered, re-possessed
Interest Rate: ID (PK), Loan ID (FK), Start Date, End Date, Rate
Transactions: ID (PK), Loan ID (FK), Date, Amount
Machine Value: ID (PK), Machine ID (FK), Amount, Date
Agreements: ID (PK)
Agreements/Loans: ID (PK), Agreements ID (FK), Loans ID (FK)
It's nowhere near complete; there's plenty of room for additional information to be recorded, but it should give you a good start.
Thanks Timothy for the reply.
It looks from the design that the relationship between Application and Loan is 1-to-1; is it correct? Also, is the transaction table going to be the table for recording the payments? I do not see how Agreement and Agreements/Loans tables will be used.
I would have that thought that the Application table should rather be Agreement table.