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 |