Customers
| CustomerID | FirstName | LastName | EmailAddress |
| 1 | John | Doe | john.doe@example.com |
| 2 | Jane | Smith | jane.smith@example.com |
Accounts
| AccountNumber | AccountType | Balance | OpenDate | CustomerID |
| | | | (→ Customers.CustomerID) |
| 1 | Checking | 1000.0 | 2023-01-01 | 1 |
| 2 | Savings | 5000.0 | 2023-02-01 | 2 |
Transactions
| TransactionID | Amount | DateAndTime | Description | AccountNumber |
| | | | (→ Accounts.AccountNumber) |
| 1 | 200.0 | 2023-03-01 10:30:00 | Groceries | 1 |
| 2 | -150.0 | 2023-03-02 14:15:00 | ATM Withdrawal | 1 |
Overdrafts
| OverdraftID | ApprovalStatus | LimitAmount | StartDate | EndDate | AccountNumber |
| | | | | (→ Accounts.AccountNumber) |
| 1 | 1 | 500.0 | 2023-04-01 | 2023-05-01 | 1 |
| 2 | 0 | 750.0 | 2023-05-01 | 2023-06-01 | 2 |
Rewards
| RewardID | Points | ExpiryDate | AccountNumber |
| | | (→ Accounts.AccountNumber) |
| 1 | 100 | 2024-01-01 | 1 |
| 2 | 200 | 2024-02-01 | 2 |
Limits
| TransactionID | Withdrawal_Limit | Atms | AccountNumber |
| | | (→ Accounts.AccountNumber) |
| 1 | 3000.0 | 2 | 1 |
| 2 | 4000.0 | 3 | 2 |