| 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 |
| 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 |
| 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. |
| 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 |
| Fee | FeeType | ProductID |
|---|---|---|
| (→ Products.ProductID) | ||
| 100.0 | Annual Fee | 1 |
| 35.0 | Late Payment Fee | 2 |
| 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 |