
🎓 Student Projects (College Reports) · Database ERD
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.
Opening a template is free and never counts toward your daily diagrams. Asking the AI to change it counts as one.
Drawing diagram…
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.
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
}An entity relationship diagram with 9 tables, 53 columns and 10 relationships.
Describe your own system in plain English and the AI ER diagram generator draws it in seconds, in the same style as this template.
Who uses a college library system and what each of them can do: members, the librarian and the system administrator.
The database of a library system: books and their copies, authors, members, loans, reservations and fines, with keys and cardinality.
How data moves through a library system: members and the librarian, the main processes, and the data stores they read and write.
The main classes of a library system with attributes, methods and UML relationships.
The steps when a member borrows a book: checks, loan record and the copy status update.
What students, examiners and the administrator do in an online examination system.