1. Consider the following transactions: Assuming initial values of X-15 and Y-25, serializable schedules of these three...
2. Consider the following two transactions: (10 points) T13: read(A); read(B); if A = 1 then B := B - 1; write(B). T14: read(B); read(A); if B = 1 then A := A - 1; write(A). Let the consistency requirement be A = 1 or B = 1, with A = 1 and B = 1 as the initial values. a. Show that every serial execution involving these two transactions preserves the consistency of the database. b. Show a concurrent...
2. Given the following three transactions T1 = r1(x); w1(y); T2 = r2(z); r2(y); w2(y); w2(x); T3 = r3(z); w3(x); r3(y); Consider the schedule S = r1(x); r3(z); r2(z); w3(x); r2(y); r3(y); w2(y); w1(y); w2(x); a. Draw the precedence graph of schedule S, and label each edge with data item(s). b. Based on the precedence graph, determine whether S is conflict serializable and justify your answer. If it is serializable, specify all possible equivalent serial schedule(s).
-Advanced Database- Consider the following transaction schedule, where time increases from top to bottom. T1 T2 T3 T4 Read (X) Read(Y) Read(Z) Read(Y) Write(Y) Write(Z) Read(U) Read(Y) Write(Y) Read(Z) Write(Z) Read(U) Write(U) Answer the following questions: Draw the precedence graph of the above schedule. Is this schedule conflict serializable? If yes, show what serial schedule(s) it is equivalent to. If not, explain why. Is this schedule view serializable? If yes, show what serial schedule(s) it is equivalent to. If not,...
Question 5. (20pts) (Briefly justify your answer) 1) Consider three transactions: T1, T2 and T3. Draw the precedence graph for the following schedule consisting of these three transactions and determine whether it is conflict serializable a) (5points) S: R1(X); R3(Z); W2(X); RI(Z); R3(Y); W2(Y), R3(Z), W1(Z), b) (5points) S: RI(X); R3(Z); W20x); RI(Y); R2(Y); W3(Y); R3(Z); WI(Z);
=T 20 marks) Consider the following PDE with boundary and initial conditions: U = Upx + ur, for 0<x< 1 and to with u(0,t) = 1, u(1,t) = 0, u(1,0) = (a) Find the steady state solution, us(1), for the PDE. (b) Let Uſz,t) = u(?, t) – us(T). Derive a PDE plus boundary and initial conditions for U(2,t). Show your working. (c) Use separation of variables to solve the resulting problem for U. You may leave the inner products...
Consider a data set consisting of values for three variables: x, y, and z. Three observations are made on each of the three variables. The following table shows the values of x, y, z, x2, y2, z2, xy, yz, and xz for each observation. Observation x y z x2 y2 z2 xy yz xz 6 6 2 36 36 4 36 12 12 4 3 8 16 9 64 12 24 32 2 6 5 4 36 25 12 30...
Consider the linear system given by the following differential equation y(4) + 3y(3) + 2y + 3y + 2y = ů – u where u = r(t) is the input and y is the output. Do not use MATLAB! a) Find the transfer function of the system (assume zero initial conditions)? b) Is this system stable? Show your work to justify your claim. Note: y(4) is the fourth derivative of y. Hint: Use the Routh-Hurwitz stability criterion! c) Write the...
Problem 3, (25 pts) Consider the integral y(t)x(t) dr where x(t)-ult +1)-u(t -1) Find the Fourier transform Y(au) by using the differentiation and the integrati domain properties. Reduce your answer t o the simplest form possible as a function of sinc(u). sin(θ)sene-o siren Formulas: sine(θ)
Please solve Q 7 & 8
7. 14+6 marks] Consider the initial value problem y_y2, 2,y(1) = 1 y'= 1-t (a) Assuming y(t) is bounded on [1, 2], Show that f(t,v)--satisfies Lipschitz condition with respect to y. (b) Use second order Taylor method with h 0.2 to approximate y(1.2), then use the Runge- Kutta method: to compute an approximation of y(1.4). 8. [4 marks) Assuming that a1, o2 are non negative constants, determine the parameters o and β1 of the...
Consider the following initial value problem: dy = sin(x - y) dx, y(0) 1. Write the equation in the form ay = G(ax +by+c), dx where a, b, and c are constants and G is a function. 2. Use the substitution u = ax + by + c to transfer the equation into the variables u and x only. 3. Solve the equation in (2). 4. Re-substitute u = ax + by + c to write your solution in terms...