What is deadlock? How can it be avoided? How can it be resolved once it occurs?

Explain the difference between optimistic and pessimistic locking.

FIGURE 8-7 EMPLOYEE STORE The Morgan Importing MIPIS Modified SALES ORDER EmployeelD StorelD StoreName City Country Phone Fax FirstName Department ax Contact INVOICE InvoiceNumber InvoiceDate StorelD(FK) ITEM TaxUSD TotalUSD ItemID ItemDescription Category INVOICE LINE ITEM InvoiceN LineNumber umber(FK) ItemlD(FK) Quantity A. Create a dependency graph that shows dependencies among the original set of tables Explain how you need to extend this stored procedures h for views and other database constructs such as