| portfolioID | name | value |
|---|---|---|
| 1 | Portfolio A | 100000.0 |
| 2 | Portfolio B | 200000.0 |
| 3 | Portfolio C | 300000.0 |
| 4 | Portfolio D | 400000.0 |
| 5 | Portfolio E | 500000.0 |
| assetTypeID | typeName | description |
|---|---|---|
| 1 | Stocks | A group of shares in a company |
| 2 | Bonds | A debt security |
| 3 | Mutual Funds | An open-ended fund that pools money from investors |
| 4 | Real Estate | Property owned by an individual or entity |
| 5 | Cryptocurrency | Digital currency designed to work as a medium of exchange |
| investmentID | assetTypeID | quantity |
|---|---|---|
| (→ Investment_Portfolios.portfolioID) | (→ Assets.assetTypeID) | |
| 1 | 1 | None |
| 2 | 1 | None |
| 3 | 1 | None |
| 4 | 1 | None |
| 5 | 1 | None |