Computers and Technology, 03.04.2021 21:30 Jeamileth

Deadlocks happen when two or more access operations happen at the same time in a database. In an HR operation, the HR Clerk is trying to delete records which will then be in the job_history and update salaries that were recommended by the Director on promotion of the records deleted, while the Senior HR Officer is trying to use salaries to calculate this month’s pay out. A third operation on the salaries involves the HR Manager who wants to know who was promoted last month so that their salaries reflect correctly in this month’s payroll. a. Write out a scenario with schematics (or diagrams) to show a typical deadlock situation that would arise as a result of the scenario given. [15]
b. What granularity would you recommend to use for each of these operations, and why? [8]
c. What would a scheduler’s role be in this scenario? Which would be best according to your understanding of deadlock resolution? [4]

d. Recommend a suitable, future solution based on:
i. Optimistic Approach. [4]
ii. Pessimistic Approach. [4]

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 21.06.2019 20:30

In the context of it jobs in the information systems field. a is responsible for database design and implementation

Answers: 3

Answer

Computers and Technology, 23.06.2019 01:20

Write a function balancechemical to balance chemical reactions by solving a linear set of equations. the inputs arguments are: reagents: symbols of reagents in string row array products: symbols of products in string row array elements: elements in the reaction in string row array elcmpreag: elemental composition of reactants in two dimensional numeric array elcmpprdcts: elemental composition of prducts in two dimensional numeric array hint: the first part of the problem is setting up the set of linear equations that should be solve. the second part of the problem is to find the integers from the solution. one way to do this is to mulitiply the rational basis for the nullspace by increasing larger integers until both the left-and right-side integers exist. for example, for the reaction that involves reacting with to produce and : reagents=["ch4", "o2"]; products =["co2", "h2o"]; elements =["c","h", "o"] elcmpreag=[1,4,0;

Answers: 3

Answer

Computers and Technology, 23.06.2019 02:30

Which component acts as a platform on which application software runs

Answers: 2

Answer

Computers and Technology, 25.06.2019 08:00

The heart of a computer.basic input/output systemselectmain memoryserial portcentral processing unit (cpu)

Answers: 3

Answer

You know the right answer?

Deadlocks happen when two or more access operations happen at the same time in a database. In an HR...