id | Name | Founding_Year | Founding_Decade | Total_Assets | Total_Liabilities | ROI_Percentage |
---|---|---|---|---|---|---|
1 | Bank A | 1800 | 19th century | 2000000.0 | 1500000.0 | 0.25 |
2 | Bank B | 1963 | 20th century | 1000000.0 | 700000.0 | 0.15 |
3 | Bank C | 1988 | 20th century | 800000.0 | 500000.0 | 0.12 |
4 | Bank D | 2000 | 21st century | 600000.0 | 400000.0 | 0.1 |
5 | Bank E | 2010 | 21st century | 400000.0 | 300000.0 | 0.08 |
id | FirstName | LastName | DateOfBirth | Address | PhoneNumber | EmailAddress | AccountId |
---|---|---|---|---|---|---|---|
(→ Accounts.id) | |||||||
1 | John | Doe | 1980-01-01 | 123 Main St | 555-1234 | john.doe@example.com | 1 |
2 | Jane | Smith | 1975-02-01 | 456 Elm St | 555-5678 | jane.smith@example.com | 2 |
3 | Alice | Johnson | 1990-03-01 | 789 Oak St | 555-9012 | alice.johnson@example.com | 3 |
4 | Michael | Williams | 1985-04-01 | 135 Pine St | 555-1357 | michael.williams@example.com | 4 |
5 | Emily | Taylor | 1995-05-01 | 246 Maple Ave | 555-2468 | emily.taylor@example.com | 5 |
id | CustomerId | Type | Balance | InterestRate | OpenDate |
---|---|---|---|---|---|
(→ Customers.id) | |||||
1 | 1 | Checking | 1000.0 | 0.01 | 2021-01-01 |
2 | 2 | Savings | 5000.0 | 0.02 | 2021-02-01 |
3 | 3 | Checking | 2000.0 | 0.01 | 2021-03-01 |
4 | 4 | Savings | 15000.0 | 0.02 | 2021-04-01 |
5 | 5 | Checking | 3000.0 | 0.01 | 2021-05-01 |
id | FromAccountId | ToAccountId | Amount | TransactionType | Date |
---|---|---|---|---|---|
(→ Accounts.id) | (→ Accounts.id) | ||||
1 | 1 | 2 | 200.0 | Transfer | 2021-01-15 |
2 | 2 | 1 | 250.0 | Transfer | 2021-01-15 |
3 | 3 | 4 | 100.0 | Transfer | 2021-03-15 |
4 | 4 | 3 | 150.0 | Transfer | 2021-03-15 |
5 | 5 | 1 | 300.0 | Deposit | 2021-05-15 |
id | BorrowerId | LenderId | PrincipalAmount | InterestRate | TermYears | MonthlyPayment | StartDate | EndDate |
---|---|---|---|---|---|---|---|---|
(→ Customers.id) | (→ Accounts.id) | |||||||
1 | 1 | 1 | 10000.0 | 0.05 | 5 | 211.23 | 2021-06-01 | 2026-06-01 |
2 | 2 | 2 | 5000.0 | 0.04 | 3 | 156.25 | 2021-07-01 | 2024-07-01 |
3 | 3 | 3 | 8000.0 | 0.06 | 4 | 228.0 | 2021-08-01 | 2025-08-01 |
4 | 4 | 4 | 7000.0 | 0.05 | 5 | 190.42 | 2021-09-01 | 2026-09-01 |
5 | 5 | 5 | 4000.0 | 0.045 | 3 | 140.0 | 2021-10-01 | 2024-10-01 |
id | PurchaserId | SecurityID | Shares | PricePerShare | CurrentValue | DatePurchased |
---|---|---|---|---|---|---|
(→ Customers.id) | (→ Securities.id) | |||||
1 | 1 | 1 | 10 | 20.0 | 200.0 | 2021-06-01 |
2 | 2 | 2 | 5 | 30.0 | 150.0 | 2021-07-01 |
3 | 3 | 3 | 8 | 25.0 | 200.0 | 2021-08-01 |
4 | 4 | 4 | 7 | 35.0 | 245.0 | 2021-09-01 |
5 | 5 | 5 | 5 | 40.0 | 200.0 | 2021-10-01 |
id | Symbol | CompanyName | Sector | Industry |
---|---|---|---|---|
1 | AAPL | Apple Inc. | Technology | Consumer Electronics |
2 | GOOG | Google LLC | Technology | Internet Services |
3 | MSFT | Microsoft Corporation | Technology | Software |
4 | AMZN | Amazon.com Inc. | Retail | E-commerce |
5 | FB | Facebook, Inc. | Technology | Social Media |