a) Describe briefly the terms ‘data integrity’ and ‘data recovery’ in the context of maintaining consistency of data in a database system. 


b) What is domain integrity? How does a database enforce domain integrity?
c) Explain the concept of checkpoints and describe, using a timeline diagram, how checkpoints are used to recover a database following failure of a transaction sequence.
d) The weather can cause devastating events in which a business can suffer permanent loss of IT infrastructure, particularly if it destroys computers/servers holding a database.
To avoid becoming a victim of catastrophic data loss, you have been recruited to prepare a plan of action that the business must enact before such a disaster.
Write the plan as a series of actions that the business would apply to minimise data loss and preserve data integrity.

Leave an answer

Sorry, you do not have permission to answer to this question .