ER Schema – bank system

All we need is an easy explanation of the problem, so here it is.

Hello i’m trying to model a simple banking scheme
where I have 3 transactions: withdraw, transfer, deposit.
of these 3 operations, the transfer is the only one that needs more attributes, I need to know the accounts participating in the transfer, and who received and who sent it.

At first I thought of something simple like that, but it seems very strange:

ER Schema - bank system

but this seems very vague to me, and when do I need the statement from the two accounts participating in the transfer?

could someone help me with this?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

The way I would initially think of this (as an accountant in a previous life) is not as a transfer, but as what is going on in MY bank’s account? One stored procedure would deduct funds from one of my member’s accounts, and a second stored procedure (initiated by the application) would send something to the other bank system to deposit funds. The record of the transfer would go into the individual account’s records as just another transaction, like a deposit or withdrawal. There would be no lasting connection between the two accounts.

Even if the transfer was between a member’s checking and savings accounts, they would still be treated as essentially two transactions going on at nearly the same time. One deposit, one withdrawal.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply