b. C. Give ONE (1) example of a situation which can lead to the violation of...

 

Transcribed Image Text:

b. C. Give ONE (1) example of a situation which can lead to the violation of the atomicity transaction property. Given the following relational schema and UPDATE command: EMP (eID, eName, eAge, eSalary, deptID) DEPT (dID, dName, dFloor) i. ii. [2 marks] UPDATE EMP Set eSalary 1.1 eSalary WHERE eName = 'Santana'; Give an example of a SQL command that would conflict with the UPDATE command in terms of concurrency control, if both were run at the same time by different users. Explain the type of transaction anomaly it invokes. [4 marks] State the approach that can be taken to avoid the problem in part (c)(i). [2 marks] b. C. Give ONE (1) example of a situation which can lead to the violation of the atomicity transaction property. Given the following relational schema and UPDATE command: EMP (eID, eName, eAge, eSalary, deptID) DEPT (dID, dName, dFloor) i. ii. [2 marks] UPDATE EMP Set eSalary 1.1 eSalary WHERE eName = 'Santana'; Give an example of a SQL command that would conflict with the UPDATE command in terms of concurrency control, if both were run at the same time by different users. Explain the type of transaction anomaly it invokes. [4 marks] State the approach that can be taken to avoid the problem in part (c)(i). [2 marks]

Answer rating: 100% (QA)

1 Situation leading to the violation of atomicity transaction property Example In a banking system i... View the full answer