Customers

CustomerIDFirstNameLastNameDateOfBirthEmailAddress
1JohnDoe2000-01-01john.doe@example.com
2JaneSmith1985-06-15jane.smith@example.com
3AliceBrown1990-10-20alice.brown@example.com

Accounts

AccountNumberBalanceInterestRateOpenDateCustomerID
(→ Customers.CustomerID)
10015000.00.012020-07-101
10023000.00.022020-08-152
10038000.00.032020-09-203

Products

ProductIDNameTypeDescription
1Premium Credit CardCredit CardA high-interest credit card with low fees.
2Basic Checking AccountChecking AccountA basic checking account with no monthly fee.
3High Yield Savings AccountSavings AccountEarn a higher interest rate on your savings balance.

CustomerAccounts

CustomerAccountIDCustomerIDAccountNumberOpenDate
(→ Customers.CustomerID)(→ Accounts.AccountNumber)
101110012020-07-10
102210022020-08-15
103310032020-09-20

CardFees

FeeTypeAmountProductID
(→ Products.ProductID)
Annual Fee100.01
Late Payment Fee35.02

MonthlyInterestRates

RateTypeRateEffectiveDateExpirationDateProductID
(→ Products.ProductID)
Fixed Rate0.012021-01-012021-12-311
Variable Rate0.032022-01-012022-12-313