הבקשה
“A bank management database with Bank, Branch, Employee, Customer, Account, Transaction, Loan, and LoanPayment tables. Branches belong to a bank and have employees; accounts and loans belong to customers and branches; transactions belong to accounts and loan payments belong to loans.”
ואז נסוAdd a credit card table linked to AccountAdd a branch address history table
מה מופיע בתרשים הזה
פענחו את ההחלטות שמאחוריו.
01
Modelling bank and branch as separate entities for scalability
02
Using many-to-one relationships for branch assignments
03
Logging transactions per account for audit trail
Suitable for core banking or fintech systems with branch-level operations.