a) Briefly explain what a transaction is;

b) Explain what a schedule is, and how it is different from a transaction;

c) Define and explain the notion of a conflict serializable schedule. Does a conflict

serializable schedule guarantee database consistency? Explain why or why not.

d) Do different conflict-serializable schedules made up of the same set of transactions leave a database in the same state (with same value of the corresponding data items) if they

started with the same state of the database? Explain your answer.

e) Explain what view serializability is, and why its being a weaker notion than conflict

serializability is also its strength.

Business rules applicable to loans at Spock Bank: Each customer is provided with a unique identifier. Details of a customer include: name, address, contact number, email address, and join date. An account can be one of three types: SAV (savings), CHK (Checking) or LON (Loan) Each type of account has a unique identifier. Each account type needs to include: name (e.g., SAV/ CHK/ LON), a description, interest rate that customers receive on deposits and a yearly service fee. No interest is paid for any money left in Loan accounts. . An account is identified by a combination of BSB and an account number. Details of account such as type of the account and current balance are stored. A loan can be one of three types: HL (Home Loan). IL (Investment Loan) and PL (Personal Loan). Each type of loan has a unique identifier. Each loan type needs to include: name (e.g, HL/ IL/ PL) and description A loan is identified by a unique identifier. Details of loan such as interest rate customers pay and total (original, not outstanding) loan amount are stored. .Every loan repayment is identified by a repayment identifier. Other details of the repayment would include: the loan that the repayment is for, repayment amount, and date and time of repayment An account type may have multiple accounts. An account will be of only one particular ype A customer may have multiple accounts. An account could be shared by multiple customers (joint account). .A loan type may have multiple loans. A loan will be of only one particular type Every loan is associated with an account. An account may not be linked with a loan. .A repayment is done for a particular loan. A loan may have multiple repayments