Re: concurrent transactions problem

From: Hammond of Texas <spammersRlosers_at_spamcop.net>
Date: Sat, 9 Oct 2004 18:09:41 -0700
Message-ID: <MPG.1bd22baf140a30c989a20@pdx.news.speakeasy.net>

In article <b9587e14.0410081114.17e0ff03_at_posting.google.com>, raj_iv123 @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 Sat Oct 09 2004 - 20:09:41 CDT