Customers
CustomerID | FirstName | LastName |
1 | John | Doe |
2 | Jane | Smith |
3 | Michael | Johnson |
4 | Emily | Williams |
5 | David | Brown |
Addresses
AddressID | CustomerID | City | Country | Banks |
| (→ Customers.CustomerID) | | | |
1 | 1 | New York | USA | Chase |
2 | 2 | Los Angeles | USA | Bank of America |
3 | 3 | Chicago | USA | Wells Fargo |
4 | 4 | Houston | USA | Capital One |
5 | 5 | Phoenix | USA | US Bank |
Accounts
AccountNumber | CustomerID | Balance | InterestRate |
| (→ Customers.CustomerID) | | |
1001 | 1 | 1000 | 2 |
1002 | 2 | 8000 | 3 |
1003 | 3 | 5000 | 2.5 |
1004 | 4 | 7000 | 3.5 |
1005 | 5 | 9000 | 3 |
Transactions
TransactionID | AccountNumber | Amount | TransactionDate |
| (→ Accounts.AccountNumber) | | |
1 | 1001 | 500 | 2021-01-01 10:00:00 |
2 | 1002 | 1000 | 2021-01-02 10:00:00 |
3 | 1003 | 600 | 2021-01-03 10:00:00 |
4 | 1004 | 800 | 2021-01-04 10:00:00 |
5 | 1005 | 1100 | 2021-01-05 10:00:00 |