Customers

CustomerIDCustomerName
1John Doe
2Jane Smith
3Michael Johnson
4Emily Davis
5David Brown

Accounts

AccountNumberCustomerIDBalance
(→ Customers.CustomerID)
112000.0
223000.0
334000.0
445000.0
556000.0

Products

ProductTypeExitFee
Exchange-Traded Product1%
Exchange-Traded Product0.75%
Unit Investment Trust1%
Unit Investment Trust0.85%

CustomerProducts

CustomerIDProductType
(→ Customers.CustomerID)
1Exchange-Traded Product
1Unit Investment Trust
2Exchange-Traded Product
2Unit Investment Trust
3Exchange-Traded Product
3Unit Investment Trust

AccountFees

AccountNumberProductTypeFeeAmount
(→ Products.ProductType)
1Exchange-Traded Product10.0
1Unit Investment Trust5.0
2Exchange-Traded Product12.0
2Unit Investment Trust6.0
3Exchange-Traded Product9.0
3Unit Investment Trust4.0
4Exchange-Traded Product8.0
4Unit Investment Trust3.0
5Exchange-Traded Product11.0
5Unit Investment Trust4.5