Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 21-04-2009
Member
 
Join Date: Feb 2009
Posts: 64
Effect of transaction on inventory

hie everyone,

I have to make a mini-project on inventory database in my college. I want to know when the transaction happens within these inventory databases, how the inventory database is affected overall ? What is the effect of transaction on the inventory ?
Any information.....kindly help
Reply With Quote
  #2  
Old 21-04-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: Effect of transaction on inventory

Here are some of the guidelines that might help you ....

A conceptual model of storage behavior is developed. Optimal intertemporal pricing is derived to analyze the effects of transaction costs on storage and arbitrage pricing. It is shown how transaction costs can rationalize the existence of an inverse carrying charge for inventory. The empirical results suggest that transaction costs have a significant influence on storage behavior and intertemporal arbitrage pricing.
Reply With Quote
  #3  
Old 21-04-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: Effect of transaction on inventory

In an inventory database, when a transaction happens, many things within the database is affected at once....say for example, when a good is sold - that particular good is added in a sales table and at the same time it is deducted from the stocks table. Also, the stocks table is checked for the minimum quantity, if it goes beyond that then the trigger occurs for demanding more goods. Also, the cost is affected and many more......
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Effect of transaction on inventory"
Thread Thread Starter Forum Replies Last Post
I need code for last purchase or transaction Date for my inventory system Max-well} Windows Software 4 05-04-2011 06:41 PM
How to get effective transaction in oracle CRiley Software Development 5 27-02-2010 02:21 AM
How to use Transaction Management in JDBC VinFanatic Software Development 3 25-04-2009 12:39 PM
Overclock and Transaction Booster! machok Overclocking & Computer Modification 3 14-02-2009 10:58 PM
HibernateTemplate and transaction Aatbodh Software Development 5 15-01-2009 11:15 PM


All times are GMT +5.5. The time now is 04:41 PM.