Re: concurrent transactions problem
Date: Sat, 9 Oct 2004 18:09:41 -0700
Message-ID: <MPG.1bd22baf140a30c989a20_at_pdx.news.speakeasy.net>
In article <b9587e14.0410081114.17e0ff03_at_posting.google.com>, raj_iv123
_at_yahoo.com says...
> Hi,
> I have a problem in my assignment that read as follows:
>
> Consider the following concurrent transactions:
> T1: Deposition of fee by the student(Information is being put in
> database system).
> T2: Creation of study center wise list of the students who have paid
> the fee.
> T3: Generation of fee Receipt details of the University.
>
> a) What may be the problems that may be encountered on concurrent
> execution of the above transactions?
>
> b) What will be the serializable schedule using hirerarchy of locks
> with intention mode locking scheme.
>
> Anyone have the solution for this? thanx in advance.
Raj,
Your professor called. He said to tell you that you have to do your own homework.
Here's a hint though. You need to ask more questions about the design of the database before you can answer those questions. Received on Sun Oct 10 2004 - 03:09:41 CEST