| CustomerID | FirstName | LastName | DateOfBirth |
|---|---|---|---|
| 1 | John | Doe | 2000-01-01 |
| 2 | Jane | Smith | 1985-06-30 |
| 3 | Michael | Johnson | 1992-07-15 |
| 4 | Emma | Williams | 1997-08-20 |
| 5 | David | Martin | 1990-09-25 |
| AccountID | CustomerID | Product | Balance |
|---|---|---|---|
| (→ Customers.CustomerID) | |||
| 1 | 1 | Checking | 1000.0 |
| 2 | 2 | Savings | 500.0 |
| 3 | 3 | Money Market | 2500.0 |
| 4 | 4 | Premium Checking | 5000.0 |
| 5 | 5 | Certificates of Deposit | 10000.0 |
| TransactionID | AccountID | Amount | Type | TransactionDate |
|---|---|---|---|---|
| (→ Accounts.AccountID) | ||||
| 1 | 1 | 500.0 | Deposit | 2024-03-13 20:52:19 |
| 2 | 2 | -100.0 | Withdrawal | 2024-03-13 20:52:19 |
| 3 | 3 | 200.0 | Deposit | 2024-03-13 20:52:19 |
| 4 | 4 | -300.0 | Withdrawal | 2024-03-13 20:52:19 |
| 5 | 5 | 2500.0 | Deposit | 2024-03-13 20:52:19 |
| FeeID | AccountID | CardFee | MonthlyFee |
|---|---|---|---|
| (→ Accounts.AccountID) | |||
| 1 | 1 | 5.0 | 10.0 |
| 2 | 2 | 3.0 | 5.0 |
| 3 | 3 | 10.0 | 20.0 |
| 4 | 4 | 20.0 | 30.0 |
| 5 | 5 | 15.0 | 40.0 |
| RateID | AccountID | MonthlyInterestRate |
|---|---|---|
| (→ Accounts.AccountID) | ||
| 1 | 1 | 0.01 |
| 2 | 2 | 0.02 |
| 3 | 3 | 0.03 |
| 4 | 4 | 0.04 |
| 5 | 5 | 0.05 |
| ProductID | Name | Description | MonthlyInterestRate | CardFee |
|---|---|---|---|---|
| 1 | Premium Credit Card | A high interest credit card. | 0.02 | 5.0 |
| 2 | Regular Credit Card | A standard credit card. | 0.01 | 3.0 |
| 3 | Business Loan | For business use only. | 0.03 | 10.0 |
| 4 | Personal Loan | Low interest personal loan. | 0.04 | 20.0 |
| 5 | Student Loan | For students only. | 0.05 | 15.0 |