Customers
CustomerID | CustomerName |
1 | John Doe |
2 | Jane Smith |
3 | Michael Johnson |
4 | Emily Davis |
5 | David Brown |
Accounts
AccountNumber | CustomerID | Balance |
| (→ Customers.CustomerID) | |
1 | 1 | 2000.0 |
2 | 2 | 3000.0 |
3 | 3 | 4000.0 |
4 | 4 | 5000.0 |
5 | 5 | 6000.0 |
Products
ProductType | ExitFee |
Exchange-Traded Product | 1% |
Exchange-Traded Product | 0.75% |
Unit Investment Trust | 1% |
Unit Investment Trust | 0.85% |
CustomerProducts
CustomerID | ProductType |
(→ Customers.CustomerID) | |
1 | Exchange-Traded Product |
1 | Unit Investment Trust |
2 | Exchange-Traded Product |
2 | Unit Investment Trust |
3 | Exchange-Traded Product |
3 | Unit Investment Trust |
AccountFees
AccountNumber | ProductType | FeeAmount |
| (→ Products.ProductType) | |
1 | Exchange-Traded Product | 10.0 |
1 | Unit Investment Trust | 5.0 |
2 | Exchange-Traded Product | 12.0 |
2 | Unit Investment Trust | 6.0 |
3 | Exchange-Traded Product | 9.0 |
3 | Unit Investment Trust | 4.0 |
4 | Exchange-Traded Product | 8.0 |
4 | Unit Investment Trust | 3.0 |
5 | Exchange-Traded Product | 11.0 |
5 | Unit Investment Trust | 4.5 |