DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Database Design

  1. #1
    Join Date
    Oct 2002
    Posts
    3

    Database Design

    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.)

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    with regard to the second quetion, you would use data from the us postal service to validate addresses. since they have such an interest in everyone getting the correct address, they sell products and listings to help with this
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    Technically, there are not "concurrent" transactions going on. No two transactions have exactly the same timestamp.

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    running balance is redundant data -- calculate it when needed, calculate it at close of business, but don't try to calculate it with each transaction.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width