1. Assuming I am building a database for a bank. How would I implement credit and debit transactions so that the running balance is computed correctly even though there are concurrent debit and credit transactions going on.

2. How would I also ensure that the zip code, city, and State code information entered into the database is correct
( I believe there is a pl/sql way of ensuring if not please describe the working of your procedure in structured english.)