Background : Bev's Boutique is a small, local business that sells hand-made products in-store only (no online sales).

8. Bev's Boutique has developed the following procedure for backup and recovery. The company backs up the entire database from the server to tape every Saturday night. The tapes are then taken to a safety deposit box at a local bank on the following Thursday. Printed paper records of all sales are kept in the shop for 5 years. If the database is ever lost, the plan is to restore the database from the last full backup and reprocess all the sales records. (10 pts)

(a) What problems might occur? (2 pts)

(b) Do you think "reprocessing" is sufficient for Bev's Boutique? (2 pts)

(c) What would be the pros and cons of using a rollback/rollforward system instead? (3 pts)

(d) Describe any changes you think the company should make to this backup/recovery system. (3 pts)

Submit the file on Titanium: (1) the completed A4_Answer.docx file.

3