Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose there are Two accounts A=700 and B=900 in a database . and we are going to move 300 from A to B , and

Suppose there are Two accounts A=700 and B=900 in a database . and we are going to move 300 from A to B , and also move 30% of A to B correspondingly . Please write two different Schedules (serial and parallel) so that both of them be correct ?

image text in transcribed

Example Schedules Let transaction T, transfer 700 Euro from account A to B and T, transfer 10% of the balance from A to B critical are the read (R) and write (W) operations Schedule 1 T, R(A) A=A-700 W(A) R(B) B=B+700 WIB) T R(A) t=A0.1 A=A-WA) R(B) B=B+tW(B) serial schedule where T, is followed by T, Schedule 2 T. R(A) A=A-700 WA) R(B) B=B+700 WIB) T. R(A) t-A-0.1 A-A-t W(A) R(B) B-B+t W(B) non-serial schedule but equivalent to Schedule 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Programming With Visual Basic .NET

Authors: Carsten Thomsen

2nd Edition

1590590325, 978-1590590324

More Books

Students also viewed these Databases questions