| CustomerID | FirstName | LastName | EmailAddress |
|---|---|---|---|
| 1 | John | Doe | john@example.com |
| 2 | Jane | Smith | jane@example.com |
| TypeID | TypeName |
|---|---|
| 1 | Checking |
| 2 | Savings |
| AccountNumber | CustomerID | AccountTypeID | Balance |
|---|---|---|---|
| (→ Customers.CustomerID) | (→ AccountTypes.TypeID) | ||
| 1 | 1 | 1 | 1000.0 |
| 2 | 2 | 2 | 500.0 |
| TransactionID | AccountNumber | ProductID | Quantity |
|---|---|---|---|
| (→ Accounts.AccountNumber) | (→ Products.ProductID) | ||
| 1 | 1 | 1 | 10 |
| 2 | 2 | 1 | 5 |
| 3 | 1 | 2 | 20 |
| 4 | 2 | 3 | 15 |
| RateId | Currency |
|---|---|
| 1 | USD |
| 2 | EUR |
| 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 |