Credit_Card

CardIDCustomerIDInterest_RateApprovalDateExpiryMonth
1115%2023-01-152026
228.99%2023-02-152027
33None2023-03-152028
4415%2023-04-152029
5512.99%2023-05-152030

Personal_Loan

LoanIDCustomerIDInterest_RateApprovedAmountPaymentTerms
1115%10000.036
228.99%5000.024
33None15000.060
4415%20000.048
5512.99%7000.048

Customers

CustomerIDFirstNameLastNameDateOfBirthAddressCityStateZipCode
1JohnDoe1990-01-01123 Main St.New YorkNY10001
2JaneSmith1985-02-02456 Elm St.ChicagoIL60601
3MichaelJackson1975-03-03789 Oak St.Los AngelesCA90001
4EmmaWatson1991-04-04999 Pine St.HoustonTX77001
5LeonardoDiCaprio1975-05-11555 Maple Ave.PhiladelphiaPA19101

Account_Links

LinkIDCustomerIDCardIDLoanID
(→ Customers.CustomerID)(→ Credit_Card.CardID)(→ Personal_Loan.LoanID)
1111
2222
3333
4444
5555