Illustrate concurrency control method by two phase locking

Assignment Help Database Management System

Reference no: EM1383812

When a race is run a number of tables need to update.

Results(EventID,CompID)
Medals(EventID,Medal,CompID)
medal is "Gold","Silver" or "Bronze"
MedalTally(Country,Medal,Number)
Competitors(CompID,Country)
Medalists(CompID,NMedals)
NMedals is total of medals for that Competitor

Suppose that when the event is completed at the venue giving CompID and position related with that EventID, then series of transactions are executed which update table shown.

a. for each table argue whether or not interference with another transaction is possible. Illustrate concurrency control method using two phase locking

b. Is there any situations in which DBMS would have to abort transaction?

Reference no: EM1383812

Questions Cloud

Important cell biology questions : Assume a migrating salmon moves from Alaskan waters past Cabo San Lucas into the Sea of Cortez, many miles south of San Diego.

Five basic characteristics of bureaucracy : Max Weber identified the five basic characteristics of bureaucracy ~ division of labor, hierarchy of authority, written rules and regulations, iimpersonality and employment based on technical qualifications.

Fed by a pollution-free stream : A lake with constant volume 10 x 10 6 m 3 is fed by a pollution-free stream with flow rate 50 m 3 /s. A factory dumps 5 m 3 /s of a nonconservative waste with concentration 100 mg/L into the lake.

Anaerobic indicator strip in an anaerobic environment : Describe why an anaerobic indicator strip in an anaerobic environment will revert to blue if it gets wet.

Illustrate concurrency control method by two phase locking : For each table argue whether or not interference with another transaction is possible. Illustrate concurrency control method using two phase locking.

What elements discussed in the case study are important : What elements discussed in the case study are important for someone who works in the field of human resources? How do the results of the quiz compare to what the case study states is ideal?

What factors prevent developing countries from becoming : What factors prevent developing countries from becoming developed? Why? What are the responsibilities of industrialized nations to developing nations in this regard

Calculate the change in the weighted distance : calculate the change in the weighted distance, wd, score if Baker exchanges the location of the tool crib and inspection.

Colonial master responsibility : What responsibilities do colonizing countries have to those that they have subjugated and colonized?

User Account

All Pages