Question: Consider a relation r(A, B, C) and a transaction T that does the following: find the maximum A value in r, and insert a new

Consider a relation r(A, B, C) and a transaction T that does the following: find the maximum A value in r, and insert a new tuple in r whose A value is 1+ the maximum A value. Assume that an index is used to find the maximum A value.

a. Suppose that the transaction locks each tuple it reads in S mode, and the tuple it creates in X mode and performs no other locking. Now suppose two instances of T are run concurrently. Explain how the resultant execution could be non-serializable.

b. Now suppose that r.A is declared as a primary key. Can the above non serializable execution occur in this case? Explain why or why not.

Step by Step Solution

★★★★★

3.40 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

the nonserializable execution can occur if both transactions are waiting f... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database System Concepts Questions!

Consider a relation R with five attributes ABCDE. 1. For each of the following instances of R, state whether it violates (a) the FD BC D and (b) the MVD BC D: (a) { } (i.e., empty relation) (b)...

Consider a relation R that has three attributes ABC. It is decomposed into relations R1 with attributes AB and R2 with attributes BC. 1. State the definition of a lossless-join decomposition with...

Write a matlab code that does the following coordinates [2,1; 3,1;4,5;2,3; 4,3] (this is just an example and the code must be able to handle all such distances)The code should be a function that...

Insert anomaly means the inability to create a new record due to the absence of other data (2 points) True False 2 Specialization S: S = {V1, V2, ..., vn) is a set of subclasses with the same...

Which one is correct w . r . t . RDBMS ? primary key super key candidate key primary key candidate key super key super key candidate key primary key super key primary key candidate key The relation...

General - Question 8 Not yet answered Consider the relation R (A, B, C, D, E, F, G, H, I) with the following functional dependencies: A, C-B, D, E, F, G AB, E, G, H, 1 CD Does the relation Rin 3NF?...

he homework is due on Feb.25 (Saturaday). Each student must submit one copy of the homework and one copy of the spool file. The following shows the file name format: Zno_FirstName_LastName_HW01.pdf...

Part AEmployee(EmpId, Lname, Fname, PosId, Supervisor, HireDate, Salary, Commission, DeptId, QualId) PosId: REFERENCES Position (PositionId) DeptId: REFERENCES Dept (DeptId) QualId: REFERENCES...

For the network from Exercise 4 calculate the conditional probability P r(p1|p2, p3) again. Apply a sampling approximate method. Discuss pros and cons of rejection sampling, likelihood weighting and...

//Database Management //Answer part 1,2,3,4,5,6 //Part 1 Consider a relation R with attributes ABCDE. You are given the following dependencies B -> C, D -> C, AE -> D. Attribute closure of A?...

Thyme Bank of New York expects new deposit inflows next month of $265 million and deposit withdrawals of $425 million The bank's economics department has projected that new loan demand will reach...

1 Boltzmann's Epitaph, an idea to die for!?! 2 At the beginning of the 20th century, Ludwig Boltzmann was one of the young physicists championing the particle view of matter. 3 Strange as it may seem...

Question Content Area Serial bonds come due in installments in periodic future dates. True False

What is the coefficient for ANALYTICAL WRITING, b3?

When processor designers consider a possible improvement to the processor datapath, the decision usually depends on the cost/performance trade-off . In the following three problems, assume that we...

Problems in this exercise assume that logic blocks needed to implement a processors datapath have the following latencies: 1. If the only thing we need to do in a processor is fetch consecutive...

For the problems in this exercise, assume that there are no pipeline stalls and that the breakdown of executed instructions is as follows: 1. In what fraction of all cycles is the data memory used?...

Aa Aa 11. Can I afford this home? Part 1 Can Maria and Sam Afford This Home Using the Monthly Income Loan Criterion? Next week, your friends Maria and Sam want to apply to the Fifth State Bank for a...

The number of compounding periods in one year is called compounding frequency. The compounding frequency affects both the present and future values of cash flows. An investor can invest money with a...

what's the correct statement of cash flows?