| CustomerID | FirstName | LastName | DateOfBirth |
|---|---|---|---|
| 1 | John | Doe | 1980-06-15 |
| 2 | Jane | Smith | 1973-08-23 |
| AccountNumber | CustomerID | AccountType | OpenDate |
|---|---|---|---|
| (→ Customers.CustomerID) | |||
| 1001 | 1 | Checking | 2021-06-01 |
| 1002 | 1 | Savings | 2021-06-01 |
| TransactionID | AccountNumber | Amount | TransactionDate |
|---|---|---|---|
| (→ Accounts.AccountNumber) | |||
| 1 | 1001 | -200 | 2021-06-01 08:00:00 |
| 2 | 1001 | 150 | 2021-06-01 09:00:00 |
| FeeID | AccountNumber | TransactionFee | MaintenanceFee | EffectiveFrom | EffectiveTo |
|---|---|---|---|---|---|
| (→ Accounts.AccountNumber) | |||||
| 1001 | 1001 | 2 | 5 | 2021-06-01 | 2022-06-01 |
| 1002 | 1001 | 2.5 | 5 | 2022-06-01 | 2023-06-01 |
| OverdraftID | AccountNumber | LimitAmount | InterestRate | ApprovalDate |
|---|---|---|---|---|
| (→ Accounts.AccountNumber) | ||||
| 1001 | 1001 | 500 | 10 | 2021-06-01 |
| 1002 | 1001 | 800 | 12 | 2021-06-01 |
| LoanID | AccountNumber | PrincipalAmount | RateOfInterest | TenureMonths | StartDate | EndDate | RepaymentMethod |
|---|---|---|---|---|---|---|---|
| (→ Accounts.AccountNumber) | |||||||
| 1001 | 1001 | 1000 | 8 | 12 | 2021-06-01 | 2023-06-01 | Equal monthly installments |
| 1002 | 1001 | 800 | 7 | 18 | 2021-06-01 | 2023-06-01 | Weekly repayments |