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 |
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 |
ManagerID | Name | 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 |
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 |
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 |
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 |