Customers

customerIDfirstNamelastNamedateOfBirthaddress
1JohnDoe1987-06-12New York
2JaneSmith1990-05-15Los Angeles
3TomNelson1975-08-18Chicago
4AliceWilliams1985-09-20Houston
5BobJackson1992-11-22Seattle

Accounts

accountIDcustomerIDbalance
(→ Customers.customerID)
111000.0
22-500.0
332000.0
44-300.0
55500.0

Mortgages

mortgageIDaccountIDloanTypeprincipalAmountannualInterestRaterepaymentPeriod
(→ Accounts.accountID)
11Mortgage100000.00.0530
22Mortgage200000.00.0625
33Home Equity Loan50000.00.0420
44Home Equity Loan30000.00.0530
55Mortgage150000.00.0715

SavingsAccounts

savingsIDaccountIDinterestRate
(→ Accounts.accountID)
110.03
220.04
330.02
440.05
550.03