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 |