## Customers

CustomerID | FirstName | LastName | DateOfBirth
--- | --- | --- | ---
1 | John | Doe | 1980-06-15
2 | Jane | Smith | 1973-08-23

## Accounts

AccountNumber | CustomerID | AccountType | OpenDate
--- | --- | --- | ---
| (→ Customers.CustomerID) |  |
1001 | 1 | Checking | 2021-06-01
1002 | 1 | Savings | 2021-06-01

## Transactions

TransactionID | AccountNumber | Amount | TransactionDate
--- | --- | --- | ---
| (→ Accounts.AccountNumber) |  |
1 | 1001 | -200 | 2021-06-01 08:00:00
2 | 1001 | 150 | 2021-06-01 09:00:00

## Fees

FeeID | AccountNumber | Fees | EffectiveFrom | EffectiveTo
--- | --- | --- | --- | ---
| (→ Accounts.AccountNumber) |  |  |
1001 | 1001 | 2 | 2021-06-01 | 2022-06-01
1002 | 1001 | 2.5 | 2022-06-01 | 2023-06-01

## Overdrafts

OverdraftID | AccountNumber | LimitAmount | InterestRate | ApprovalDate
--- | --- | --- | --- | ---
| (→ Accounts.AccountNumber) |  |  |
1001 | 1001 | 500 | 10 | 2021-06-01
1002 | 1001 | 800 | 12 | 2021-06-01

## Loans

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