| ID | Name |
|---|---|
| 1 | Contactless Transaction |
| 2 | Withdrawal Only |
| ID | Name | Address | POSID |
|---|---|---|---|
| (→ Point_of_Sale_Terminals.ID) | |||
| 1 | ATM1 | Main Street | 1 |
| 2 | ATM2 | Highway 10 | None |
| ID | Name | Address | AtmID | CapabilityID |
|---|---|---|---|---|
| (→ ATMs.ID) | (→ Capabilities.ID) | |||
| 1 | POS1 | Shopping Mall | 3 | 1 |
| 2 | POS2 | Grocery Store | None | 2 |
| ID | FirstName | LastName | DOB | AccountNumber |
|---|---|---|---|---|
| (→ Accounts.Number) | ||||
| 1 | John | Doe | 1980-01-01 | 1001 |
| 2 | Jane | Smith | 1975-06-15 | 1002 |
| 3 | Alice | Brown | 1990-07-22 | 1003 |
| Number | Balance | Type | CustomerID |
|---|---|---|---|
| (→ Customers.ID) | |||
| 1001 | 1000 | Checking | 1 |
| 1002 | 500 | Savings | 2 |
| 1003 | 2000 | Checking | 3 |
| ID | Amount | Date | Description | FromID | ToID |
|---|---|---|---|---|---|
| (→ Accounts.Number) | (→ Accounts.Number) | ||||
| 1 | 500 | 2021-01-01 | Payment | 1001 | 1002 |
| 2 | -200 | 2021-01-02 | Withdrawal | 1001 | 1001 |
| 3 | 250 | 2021-01-03 | Transfer | 1002 | 1003 |