(7 5 7 5 15) The HR and Accounts departments of an organization wish to update the designation and salary of an employee from Asst Engineer to Exec Engineer and Rs 20,000 to Rs 25,000 respectively Data about employees is available in a relation, Employee(Eno, Ename, Designation, Salary) (a) Can there be lost updates If yes then build a schedule to show this Can there be dirty reads If not, then why not If yes, then build a schedule to show this (b) Can there be unrepeatable reads If not then why not If yes, then build a schedule to show this For the schedule of lost updates of (a) above, use the time stamping technique of optimistic serializability and show if it results in rollback or not

Question

(7 5 7 5  15) The HR and Accounts departments of an organization wish to update the designation and salary of an employee from Asst  Engineer to Exec  Engineer and Rs  20,000 to Rs  25,000 respectively  Data about employees is available in a relation, Employee(Eno, Ename, Designation, Salary)  (a) Can there be lost updates  If yes then build a schedule to show this  Can there be dirty reads  If not, then why not  If yes, then build a schedule to show this (b) Can there be unrepeatable reads  If not then why not  If yes, then build a schedule to show this  For the schedule of lost updates of (a) above, use the time stamping technique of optimistic serializability and show if it results in rollback or not

Accepted Answer

The Answer is in the image, click to view ...

Question

(7.5+7.5= 15) The HR and Accounts departments of an organization wish to update the designation and salary of an employee from Asst. Engineer to Exec.

Step by Step Solution

Step: 1

Get Instant Access with AI-Powered Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question