QUESTION: Give an example of a query or statement that would conflict with the a

Question

QUESTION: Give an example of a query or statement that would conflict with the above UPDATE statement (when run concurrently) and would lock the table exclusively (write lock) at page/file level.

Branch Publisher Em ployee EmployeeID CHAR(8) BranchID INT Branch Name VARCHAR(45) Branch Address VARCHAR … ONumberOfEmployees INT PublisherID CHAR(3) PublisherName VARCHAR(45) PublisherCity VARCHAR (30) Publish&Contactio; AR(10) EmployeeName VARCHAR(45) EmployeeType VARCHAR(20) Supervisor-EmployeeID CH Indexes Indexes Inventory DutyRoster EmployeeID CHAR(8) BranchID INT t Branch_BranchID INT Book_BookID INT AvailableQuantity INT Indexes t WorkingShiftID INT Book BookID INT WorkingShift WorkingShiftID INT workingShiftWeekDay VARCHAR (15) workingShiftStartTime TIME(6) WorkingShiftEndTim e TIME(6) dutyType VARAR(20) Indexes BookTitle VARCHAR(45) BookType VARCHAR (45) Book Price DECIMAL (8,2) 1sPaperback VARCHAR(3) Writes Author_AuthorID INT Book_BookID INT Author AuthorID INT AuthorName VARCHAR(45) AuthorE mail Address V ARCHAR (45) Indexes sequenceNumber INT Publisher, Publisher!D CHAR(3) Indexes Figure 1 : Relational Data Model

Explanation / Answer

this dutyRoster take resource from employeeID, workingShiftID and branchID.

Inventory hold branchID and BookID

and writer take AuthorID and BookID

now suppose Writer take BookID and wait for AuthorID but that AuthorID take by Author, similary Inventory can not fulfill its work because BookId not with it but it take BranchID.

Likewise InDutyRostor cannot take BranchID because it have EmployeeID and WorkingshiftID.

Now here when we try to update Workingshift it can not possible it may have starvation or deadlock

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---