Capabilities

IDName
1Contactless Transaction
2Withdrawal Only

ATMs

IDNameAddressPOSID
(→ Point_of_Sale_Terminals.ID)
1ATM1Main Street1
2ATM2Highway 10None

Point_of_Sale_Terminals

IDNameAddressAtmIDCapabilityID
(→ ATMs.ID)(→ Capabilities.ID)
1POS1Shopping Mall31
2POS2Grocery StoreNone2

Customers

IDFirstNameLastNameDOBAccountNumber
(→ Accounts.Number)
1JohnDoe1980-01-011001
2JaneSmith1975-06-151002
3AliceBrown1990-07-221003

Accounts

NumberBalanceTypeCustomerID
(→ Customers.ID)
10011000Checking1
1002500Savings2
10032000Checking3

Transactions

IDAmountDateDescriptionFromIDToID
(→ Accounts.Number)(→ Accounts.Number)
15002021-01-01Payment10011002
2-2002021-01-02Withdrawal10011001
32502021-01-03Transfer10021003