Central_Banks
id | Name | Country | Year_Founded | Currency |
1 | Federal Reserve | USA | 2014 | USD |
2 | European Central Bank | Germany | 1998 | Euro |
Commercial_Banks
id | Name | Country | Assets | Headquarter_City |
1 | Citibank | USA | 300000000000.0 | New York |
2 | HSBC | UK | 670000000000.0 | London |
Customers
id | FirstName | LastName | DateOfBirth | AccountNumber |
1 | John | Smith | 1990-01-01 | 1234567890 |
2 | Jane | Doe | 2000-02-02 | 2345678901 |
Loans
id | CustomerID | Principal | InterestRate | StartDate | EndDate |
| (→ Customers.id) | | | | |
1 | 1 | 100000 | 4.5 | 2022-01-01 | 2025-12-31 |
2 | 2 | 200000 | 3.0 | 2022-01-15 | 2025-12-15 |
SavingsAccounts
id | CustomerID | Balance | InterestRate | OpeningDate |
| (→ Customers.id) | | | |
1 | 1 | 50000.0 | 1.5 | 2021-01-01 |
2 | 2 | 30000.0 | 2.0 | 2021-02-01 |
Transactions
id | FromAccount | ToAccount | Amount | TransactionType | Date |
| (→ SavingsAccounts.id) | (→ SavingsAccounts.id) | | | |
1 | 1 | 2 | 5000.0 | Deposit | 2024-03-13 18:48:25 |
2 | 1 | 2 | -2500.0 | Withdrawal | 2024-03-13 18:48:25 |