Customers
CustomerID | Name | Email | PhoneNumber |
1 | John Doe | john@example.com | 1234567890 |
2 | Jane Smith | jane@example.com | 0987654321 |
Accounts
AccountID | CustomerID | AccountType | Balance |
| (→ Customers.CustomerID) | | |
1 | 1 | Checking | 1000.0 |
2 | 2 | Savings | 500.0 |
Assets
AssetID | AccountID | AssetName | AssetValue |
| (→ Accounts.AccountID) | | |
1 | 1 | Stock A | 1000.0 |
2 | 2 | Bond B | 500.0 |
Funds
FundID | FundStructure | MarketShare | TotalAssets |
1 | Hedge Fund | 2% | 10000.0 |
2 | Hedge Fund | 5% | 20000.0 |
3 | Mutual Fund | 2% | 15000.0 |
4 | Mutual Fund | 3% | 25000.0 |
Transactions
TransactionID | FromAccountID | ToAccountID | Amount | TransactionDate |
| (→ Accounts.AccountID) | (→ Accounts.AccountID) | | |
1 | 1 | 2 | -250.0 | 2021-10-01 |
2 | 2 | 1 | 200.0 | 2021-10-02 |
3 | 1 | 2 | -200.0 | 2021-10-03 |
4 | 2 | 1 | -250.0 | 2021-10-04 |
5 | 1 | 2 | 100.0 | 2021-10-05 |
Investments
InvestmentID | AccountID | FundID | Shares |
| (→ Accounts.AccountID) | (→ Funds.FundID) | |
1 | 1 | 1 | 10 |
2 | 2 | 2 | 20 |
3 | 1 | 3 | 5 |
4 | 2 | 4 | 10 |
5 | 1 | 1 | 15 |