ClientID | FirstName | LastName | PhoneNumber | StreetAddress | City | State | ZipCode | |
---|---|---|---|---|---|---|---|---|
1 | John | Doe | john.doe@gmail.com | 1234567890 | 123 Main St | Springfield | IL | 62701 |
2 | Jane | Smith | jane.smith@gmail.com | 9876543210 | 456 Elm St | Chicago | IL | 60601 |
3 | Mike | Brown | mike.brown@gmail.com | 1357924680 | 789 Oak St | Peoria | IL | 61602 |
4 | Alice | Wonderland | alice.wonderland@gmail.com | 4209876543 | 246 Pine St | Rockford | IL | 61071 |
5 | Steve | King | steve.king@gmail.com | 1135876420 | 321 Maple St | Quincy | IL | 62301 |
CardID | ClientID | CardNumber | ExpiryDate | SecurityCode | InterestRate |
---|---|---|---|---|---|
(→ Clients.ClientID) | |||||
1 | 1 | 1234567890123456 | 2023-12-31 | 123 | 15.0 |
2 | 2 | 2345678901234567 | 2023-12-31 | 456 | 13.0 |
3 | 3 | 3456789012345678 | 2024-12-31 | 789 | 12.0 |
4 | 4 | 4567890123456789 | 2024-12-31 | 135 | 11.0 |
5 | 5 | 5678901234567890 | 2025-12-31 | 246 | 10.0 |
LoanID | ClientID | LoanAmount | LoanTermYears | ApprovedDate | DisbursedDate | InterestRate | MonthlyPayment |
---|---|---|---|---|---|---|---|
(→ Clients.ClientID) | |||||||
1 | 1 | 50000 | 5 | 2022-01-01 | 2022-02-01 | 15.0 | None |
2 | 2 | 60000 | 7 | 2022-02-01 | 2022-03-01 | 13.0 | None |
3 | 3 | 70000 | 5 | 2022-03-01 | 2022-04-01 | 12.0 | None |
4 | 4 | 80000 | 7 | 2022-04-01 | 2022-05-01 | 11.0 | None |
5 | 5 | 90000 | 8 | 2022-05-01 | 2022-06-01 | 10.0 | None |
AccountID | ClientID | Balance | OpenDate | AnnualInterestRate |
---|---|---|---|---|
(→ Clients.ClientID) | ||||
1 | 1 | 1000 | 2022-01-01 | 2.5 |
2 | 2 | 2000 | 2022-02-01 | 2.25 |
3 | 3 | 3000 | 2022-03-01 | 2.0 |
4 | 4 | 4000 | 2022-04-01 | 1.75 |
5 | 5 | 5000 | 2022-05-01 | 1.5 |