## Capabilities

ID | Name
--- | ---
1 | Contactless Transaction
2 | Withdrawal Only

## ATMs

ID | Name | Address | POSID
--- | --- | --- | ---
|  |  | (→ Point_of_Sale_Terminals.ID)
1 | ATM1 | Main Street | 1
2 | ATM2 | Highway 10 | None

## Point_of_Sale_Terminals

ID | Name | Address | AtmID | CapabilityID
--- | --- | --- | --- | ---
|  |  | (→ ATMs.ID) | (→ Capabilities.ID)
1 | POS1 | Shopping Mall | 3 | 1
2 | POS2 | Grocery Store | None | 2

## Customers

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

## Accounts

Number | Balance | Type | CustomerID
--- | --- | --- | ---
|  |  | (→ Customers.ID)
1001 | 1000 | Checking | 1
1002 | 500 | Savings | 2
1003 | 2000 | Checking | 3

## Transactions

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