## Customers

CustomerID | FirstName | LastName | EmailAddress
--- | --- | --- | ---
1 | John | Doe | john@example.com
2 | Jane | Smith | jane@example.com

## AccountTypes

TypeID | TypeName
--- | ---
1 | Checking
2 | Savings

## Accounts

AccountNumber | CustomerID | AccountTypeID | Balance
--- | --- | --- | ---
| (→ Customers.CustomerID) | (→ AccountTypes.TypeID) |
1 | 1 | 1 | 1000.0
2 | 2 | 2 | 500.0

## Transactions

TransactionID | AccountNumber | ProductID | Quantity
--- | --- | --- | ---
| (→ Accounts.AccountNumber) | (→ Products.ProductID) |
1 | 1 | 1 | 10
2 | 2 | 1 | 5
3 | 1 | 2 | 20
4 | 2 | 3 | 15

## ExchangeRates

RateId | Currency
--- | ---
1 | USD
2 | EUR

## Products

ProductID | Name | Description | ExitFee | Category
--- | --- | --- | --- | ---
1 | Exchange-Traded Product | This product tracks an index. | 0.01 | ETP
2 | Another Exchange-Traded Product | Another ETP tracking a different index. | 0.02 | ETP
3 | Unit Investment Trust | A trust investing in various assets. | 0.01 | UIT
4 | Another Unit Investment Trust | Another UIT with different asset allocation. | 0.02 | UIT