JSR CSI Company

Order Collection

Research DB view

Zoho Registration for VGSOM students

Summers Feedback : Summary View

Basic Order Collection Application

Simple "Bank" Transactions

This application a rudimentary banking style transaction where two types of actions are possible.

1. Receipt : where money is added to an account
2. Payment : where money is subtracted from an account

This application also demonstrates

1. Usage of two tables linked through a foreign key. Unless an account has been created, no transactions are possible against the account
2. If the transaction is a payment, the balance decreases. If the transaction is a receipt, the balance increases.
3. If the payment is more than balance available, the transaction is not allowed to go through
4. If the balance falls below a certain value, an email is sent to the account holder.
5. All this through a persistent relational database

..........................................................................................................................................

Here is the main Transaction Screen


...........................................................................................................................................


...........................................................................................................................................

as well as the Accounts Balance File



...........................................................................................................................................

the balances would get updated when this page is refreshed