Clients

ClientIDFirstNameLastNameEmailPhoneNumberStreetAddressCityStateZipCode
1JohnDoejohn.doe@gmail.com1234567890123 Main StSpringfieldIL62701
2JaneSmithjane.smith@gmail.com9876543210456 Elm StChicagoIL60601
3MikeBrownmike.brown@gmail.com1357924680789 Oak StPeoriaIL61602
4AliceWonderlandalice.wonderland@gmail.com4209876543246 Pine StRockfordIL61071
5SteveKingsteve.king@gmail.com1135876420321 Maple StQuincyIL62301

Credit_Card

CardIDClientIDCardNumberExpiryDateSecurityCodeInterestRate
(→ Clients.ClientID)
1112345678901234562023-12-3112315.0
2223456789012345672023-12-3145613.0
3334567890123456782024-12-3178912.0
4445678901234567892024-12-3113511.0
5556789012345678902025-12-3124610.0

Personal_Loans

LoanIDClientIDLoanAmountLoanTermYearsApprovedDateDisbursedDateInterestRateMonthlyPayment
(→ Clients.ClientID)
115000052022-01-012022-02-0115.0None
226000072022-02-012022-03-0113.0None
337000052022-03-012022-04-0112.0None
448000072022-04-012022-05-0111.0None
559000082022-05-012022-06-0110.0None

Savings_Accounts

AccountIDClientIDBalanceOpenDateAnnualInterestRate
(→ Clients.ClientID)
1110002022-01-012.5
2220002022-02-012.25
3330002022-03-012.0
4440002022-04-011.75
5550002022-05-011.5