## Customers

CustomerID | FirstName | LastName | DateOfBirth | EmailAddress
--- | --- | --- | --- | ---
1 | John | Doe | 2000-01-01 | john.doe@example.com
2 | Jane | Smith | 1985-06-15 | jane.smith@example.com
3 | Alice | Brown | 1990-10-20 | alice.brown@example.com

## Accounts

AccountNumber | Balance | InterestRate | OpenDate | CustomerID
--- | --- | --- | --- | ---
|  |  |  | (→ Customers.CustomerID)
1001 | 5000.0 | 0.01 | 2020-07-10 | 1
1002 | 3000.0 | 0.02 | 2020-08-15 | 2
1003 | 8000.0 | 0.03 | 2020-09-20 | 3

## Products

ProductID | Name | Type | Description
--- | --- | --- | ---
1 | Premium Credit Card | Credit Card | A high-interest credit card with low fees.
2 | Basic Checking Account | Checking Account | A basic checking account with no monthly fee.
3 | High Yield Savings Account | Savings Account | Earn a higher interest rate on your savings balance.

## CustomerAccounts

CustomerAccountID | CustomerID | AccountNumber | OpenDate
--- | --- | --- | ---
| (→ Customers.CustomerID) | (→ Accounts.AccountNumber) |
101 | 1 | 1001 | 2020-07-10
102 | 2 | 1002 | 2020-08-15
103 | 3 | 1003 | 2020-09-20

## CardFees

Fee | FeeType | ProductID
--- | --- | ---
|  | (→ Products.ProductID)
100.0 | Annual Fee | 1
35.0 | Late Payment Fee | 2

## MonthlyInterestRates

Rate | RateType | EffectiveDate | ExpirationDate | ProductID
--- | --- | --- | --- | ---
|  |  |  | (→ Products.ProductID)
0.01 | Fixed Rate | 2021-01-01 | 2021-12-31 | 1
0.03 | Variable Rate | 2022-01-01 | 2022-12-31 | 3