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 |