| CustomerID | FirstName | LastName | EmailAddress |
|---|---|---|---|
| 1 | John | Doe | john.doe@example.com |
| 2 | Jane | Smith | jane.smith@example.com |
| AccountNumber | CustomerID | Balance |
|---|---|---|
| (→ Customers.CustomerID) | ||
| 1 | 1 | 1000.0 |
| 2 | 2 | 800.0 |
| ExchangeID | CurrencyText | YearOfEstablishment | CurrencyExchangeService |
|---|---|---|---|
| (→ Years.Year) | |||
| 1 | USD/EUR | 2000 | 1 |
| 2 | GBP/CAD | 2010 | 0 |
| FirmID | Name | YearOfEstablishment |
|---|---|---|
| (→ Years.Year) | ||
| 1 | Goldman Sachs | 2000 |
| 2 | Morgan Stanley | 2010 |
| Year | Description |
|---|---|
| 2000 | The beginning of a new century. |
| 2010 | A decade has passed since the turn of the millennium. |
| TransactionID | AccountNumber | Amount | TransferDate | ForeignAccountNumber |
|---|---|---|---|---|
| (→ Accounts.AccountNumber) | (→ Accounts.AccountNumber) | |||
| 1 | 1 | 700.0 | 2023-04-01 12:00:00 | 2 |
| 2 | 2 | 900.0 | 2023-04-01 12:00:00 | 3 |