需求
“Create an ATM transaction ERD with the shown customer, account, ATM, transaction, card, and branch tables, their keys and attributes, and the shown account, card, ATM, and transaction relationships.”
接著試試Add cash replenishment.Add transaction fees.
這張圖裡有什麼
看懂背後的決策。
01
Separated Account and Loan as distinct entities due to different attributes and behaviors
02
Linked each financial product to both Customer and Branch for ownership and management tracking
03
Included Employee entity to represent branch staff, linking to Branch for employment relationship
Applicable to any retail banking system, from small credit unions to large commercial banks, requiring core banking functionality and customer management.