Customers

CustomerIDFirstNameLastNameEmailAddress
1JohnDoejohn@example.com
2JaneSmithjane@example.com

AccountTypes

TypeIDTypeName
1Checking
2Savings

Accounts

AccountNumberCustomerIDAccountTypeIDBalance
(→ Customers.CustomerID)(→ AccountTypes.TypeID)
1111000.0
222500.0

Transactions

TransactionIDAccountNumberProductIDQuantity
(→ Accounts.AccountNumber)(→ Products.ProductID)
11110
2215
31220
42315

ExchangeRates

RateIdCurrency
1USD
2EUR

Products

ProductIDNameDescriptionExitFeeCategory
1Exchange-Traded ProductThis product tracks an index.0.01ETP
2Another Exchange-Traded ProductAnother ETP tracking a different index.0.02ETP
3Unit Investment TrustA trust investing in various assets.0.01UIT
4Another Unit Investment TrustAnother UIT with different asset allocation.0.02UIT