CloudSketch AI Logo
FeaturesTemplatesPricingEnterpriseAboutContactLog in
🌙☀️
Log inStart free
Home/Templates/Student Projects (College Reports)

🎓 Student Projects (College Reports) · Database ERD

ATM System ER Diagram

The database of an ATM banking system: customers, accounts, debit cards, ATMs and their cash cassettes, transactions, cash refills by technicians and an audit log.

More Student Projects (College Reports) templates

Opening a template is free and never counts toward your daily diagrams. Asking the AI to change it counts as one.

Drawing diagram…

What this diagram shows

  • Transfers link a source and a destination account
  • Cash cassettes per ATM by denomination
  • PIN stored only as a hash

Prompt used

ER diagram for an ATM banking system: customers with accounts, debit cards linked to an account with PIN hash and status, ATMs with location and cash balance, transactions (withdrawal, deposit, transfer, balance enquiry) with amount, time and status made at an ATM with a card, and cash refills of an ATM by a technician.

Mermaid code
erDiagram
CUSTOMER ||--o{ ACCOUNT : "owns"
ACCOUNT ||--o{ DEBIT_CARD : "issues"
ACCOUNT ||--o{ TRANSACTION : "source_for"
ACCOUNT ||--o{ TRANSACTION : "destination_for"
DEBIT_CARD ||--o{ TRANSACTION : "authorizes"
ATM ||--o{ TRANSACTION : "processes"
ATM ||--o{ CASH_REFILL : "receives"
TECHNICIAN ||--o{ CASH_REFILL : "performs"
ATM ||--o{ ATM_CASSETTE : "contains"
TRANSACTION ||--o{ AUDIT_LOG : "generates"

CUSTOMER {
    uuid id PK
    string full_name
    string national_id
    string email
    timestamp created_at
}

ACCOUNT {
    uuid id PK
    uuid customer_id FK
    string account_number
    string account_type
    decimal balance
    timestamp created_at
}

DEBIT_CARD {
    uuid id PK
    uuid account_id FK
    string card_number
    string pin_hash
    string card_status
    date expiration_date
}

ATM {
    uuid id PK
    string terminal_id
    string location_address
    decimal total_cash_balance
    string status
    timestamp last_ping
}

ATM_CASSETTE {
    uuid id PK
    uuid atm_id FK
    integer denomination
    integer bill_count
    decimal total_value
}

TRANSACTION {
    uuid id PK
    uuid card_id FK
    uuid atm_id FK
    uuid source_account_id FK
    uuid destination_account_id FK
    string transaction_type
    decimal amount
    string transaction_status
    timestamp created_at
}

TECHNICIAN {
    uuid id PK
    string employee_code
    string full_name
    string phone_number
    timestamp created_at
}

CASH_REFILL {
    uuid id PK
    uuid atm_id FK
    uuid technician_id FK
    decimal amount_added
    decimal balance_after
    timestamp refilled_at
}

AUDIT_LOG {
    uuid id PK
    uuid transaction_id FK
    string event_type
    string payload
    timestamp logged_at
}

Inside this diagram

An entity relationship diagram with 9 tables, 53 columns and 10 relationships.

Tables and their columns

  • CUSTOMER: id (PK), full_name, national_id, email, created_at
  • ACCOUNT: id (PK), customer_id (FK), account_number, account_type, balance, created_at
  • DEBIT_CARD: id (PK), account_id (FK), card_number, pin_hash, card_status, expiration_date
  • TRANSACTION: id (PK), card_id (FK), atm_id (FK), source_account_id (FK), destination_account_id (FK), transaction_type, amount, transaction_status, created_at
  • ATM: id (PK), terminal_id, location_address, total_cash_balance, status, last_ping
  • CASH_REFILL: id (PK), atm_id (FK), technician_id (FK), amount_added, balance_after, refilled_at
  • TECHNICIAN: id (PK), employee_code, full_name, phone_number, created_at
  • ATM_CASSETTE: id (PK), atm_id (FK), denomination, bill_count, total_value
  • AUDIT_LOG: id (PK), transaction_id (FK), event_type, payload, logged_at

Relationships

  • CUSTOMER owns ACCOUNT: each CUSTOMER has zero or more ACCOUNT, each ACCOUNT belongs to exactly one CUSTOMER
  • ACCOUNT issues DEBIT_CARD: each ACCOUNT has zero or more DEBIT_CARD, each DEBIT_CARD belongs to exactly one ACCOUNT
  • ACCOUNT source_for TRANSACTION: each ACCOUNT has zero or more TRANSACTION, each TRANSACTION belongs to exactly one ACCOUNT
  • ACCOUNT destination_for TRANSACTION: each ACCOUNT has zero or more TRANSACTION, each TRANSACTION belongs to exactly one ACCOUNT
  • DEBIT_CARD authorizes TRANSACTION: each DEBIT_CARD has zero or more TRANSACTION, each TRANSACTION belongs to exactly one DEBIT_CARD
  • ATM processes TRANSACTION: each ATM has zero or more TRANSACTION, each TRANSACTION belongs to exactly one ATM
  • ATM receives CASH_REFILL: each ATM has zero or more CASH_REFILL, each CASH_REFILL belongs to exactly one ATM
  • TECHNICIAN performs CASH_REFILL: each TECHNICIAN has zero or more CASH_REFILL, each CASH_REFILL belongs to exactly one TECHNICIAN
  • ATM contains ATM_CASSETTE: each ATM has zero or more ATM_CASSETTE, each ATM_CASSETTE belongs to exactly one ATM
  • TRANSACTION generates AUDIT_LOG: each TRANSACTION has zero or more AUDIT_LOG, each AUDIT_LOG belongs to exactly one TRANSACTION

Make your own diagram like this

Describe your own system in plain English and the AI ER diagram generator draws it in seconds, in the same style as this template.

Related templates

Use CaseStudent Projects (College Reports)

Library Management System Use Case Diagram

Who uses a college library system and what each of them can do: members, the librarian and the system administrator.

Database ERDStudent Projects (College Reports)

Library Management System ER Diagram

The database of a library system: books and their copies, authors, members, loans, reservations and fines, with keys and cardinality.

Data FlowStudent Projects (College Reports)

Library Management System Data Flow Diagram (Level 1)

How data moves through a library system: members and the librarian, the main processes, and the data stores they read and write.

Class UMLStudent Projects (College Reports)

Library Management System Class Diagram

The main classes of a library system with attributes, methods and UML relationships.

SequenceStudent Projects (College Reports)

Library Management System Sequence Diagram (Issue a Book)

The steps when a member borrows a book: checks, loan record and the copy status update.

Use CaseStudent Projects (College Reports)

Online Examination System Use Case Diagram

What students, examiners and the administrator do in an online examination system.