## Customers

CustomerID | FirstName | LastName | DateOfBirth
--- | --- | --- | ---
1 | John | Doe | 2000-01-01
2 | Jane | Smith | 1985-06-15
3 | Michael | Johnson | 1970-11-22
4 | Emily | Williams | 1992-02-27
5 | David | Brown | 1988-03-10

## Accounts

AccountNumber | Balance | InterestRate | CustomerID
--- | --- | --- | ---
|  |  | (→ Customers.CustomerID)
10001 | 1000.0 | 0.01 | 1
10002 | 5000.0 | 0.02 | 2
10003 | 2000.0 | 0.01 | 3
10004 | 3000.0 | 0.02 | 4
10005 | 4000.0 | 0.03 | 5

## AssetManagers

ManagerID | Name | Email | PhoneNumber
--- | --- | --- | ---
1 | Alice Smith | alice@example.com | +1-234-567-8901
2 | Bob Johnson | bob@example.com | +1-345-678-9012
3 | Carol Williams | carol@example.com | +1-456-789-0123
4 | Dan Brown | dan@example.com | +1-567-890-1234
5 | Eva Davis | eva@example.com | +1-678-901-2345

## Investments

InvestmentID | Shares | PurchaseDate | AccountNumber | FundID
--- | --- | --- | --- | ---
|  |  | (→ Accounts.AccountNumber) | (→ MutualFunds.FundID)
1 | 100 | 2022-01-01 | 10001 | 1
2 | 200 | 2022-02-01 | 10002 | 2
3 | 150 | 2022-03-01 | 10003 | 3
4 | 250 | 2022-04-01 | 10004 | 4
5 | 300 | 2022-05-01 | 10005 | 5

## Transactions

TransactionID | Amount | Type | Description | AccountNumber | InvestmentID
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Accounts.AccountNumber) | (→ Investments.InvestmentID)
1 | 500.0 | Deposit | Initial deposit | 10001 | None
2 | 200.0 | Withdrawal | ATM withdrawal | 10001 | None
3 | 300.0 | Transfer | Transfer to another account | 10002 | None
4 | 400.0 | Deposit | Paycheck deposited | 10002 | None
5 | 500.0 | Withdrawal | Payment of bills | 10003 | None

## MutualFunds

FundID | TickerSymbol | NetAssets | Investment_Managerment
--- | --- | --- | ---
|  |  | (→ AssetManagers.ManagerID)
1 | ABCD | 1000000.0 | 1
2 | EFGH | 2000000.0 | 2
3 | IJKL | 3000000.0 | 3
4 | MNOP | 4000000.0 | 4
5 | QRST | 5000000.0 | 5