(a) Differentiate between stored procedure and trigger in Structured Query Language (SQL). (b) What are the properties of a transaction? How…

(a) Differentiate between stored procedure and trigger in Structured Query Language (SQL).

(b) What are the properties of a transaction? How concurrent transactions are managed? Explain any concurrency control mechanism.

(c) In a payroll management system, the salary of everyone working in a company is managed. The salary comprises several components, such as, basic, house rent (a certain percentage of basic), medical allowance, etc. and deductible components like PF contribution, insurance subscription etc. If an employee takes a loan, the repayment is adjusted at the beginning of the next month, basic of all employees are incremented following a rule which defines the percentage of increment. However, each salary grade has a maximum bound. The increment will be applicable within this bound. Draw an Entity Relationship (ER) diagram of this payroll management system.