## Customers

CustomerID | FirstName | LastName | DateOfBirth | Email
--- | --- | --- | --- | ---
1 | John | Doe | 1980-06-12 | john.doe@example.com
2 | Jane | Smith | 1975-03-18 | jane.smith@example.com

## Accounts

AccountNumber | Balance | Type | CustomerID
--- | --- | --- | ---
|  |  | (→ Customers.CustomerID)
1 | 1000.0 | Checking | 1
2 | 5000.0 | Savings | 1

## Transactions

TransactionID | Amount | Date | Description | FromAccountNumber | ToAccountNumber
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Accounts.AccountNumber) | (→ Accounts.AccountNumber)
1 | 500.0 | 2021-08-15 10:00:00 | Transfer to Savings | 1 | 2
2 | -200.0 | 2021-08-15 14:00:00 | Payment | 2 | 3

## Loans

LoanID | PrincipalAmount | InterestRate | StartDate | EndDate | CustomerID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Customers.CustomerID)
1 | 15000.0 | 5.5 | 2021-09-01 | 2026-08-31 | 1
2 | 20000.0 | 4 | 2021-10-01 | 2028-09-30 | 2

## Employees

EmployeeID | FirstName | LastName | HireDate | Position | Salary
--- | --- | --- | --- | --- | ---
1 | Alice | Johnson | 2018-05-01 | Manager | 60000.0
2 | Michael | Williams | 2019-10-01 | Assistant Manager | 45000.0

## FinancialServices

FinancialServiceID | Organization | ServiceType | CostReal | EmployeeID
--- | --- | --- | --- | ---
|  |  |  | (→ Employees.EmployeeID)
1 | ABC Group | Custodial Service | 1000.0 | 1
2 | XYZ Company | Custodial Service | 1200.0 | 2
3 | ABC Group | Trust Administration | 1500.0 | 3
4 | PQR Corporation | Trust Administration | 1800.0 | 4