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 |