Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

6 (a) Outline four states of transactions in a database management system. (4 marks) (b) Explain a circumstance under which each of the following

image text in transcribed

6 (a) Outline four states of transactions in a database management system. (4 marks) (b) Explain a circumstance under which each of the following anomalies may occur in un normalised database: (i) update; (2 marks) (ii) deletion; (2 marks) (iii) insert. (c) Explain the term data replication as used in Database Management system. (2 marks) (2 marks) (d) A company's database experienced system failure. (i) (ii) Explain two recovery techniques in which the company should have used in order to recover the data. (4 marks) During the recovery, there was a transaction failure. Explain a reason that may have caused each of the following types of errors. 1. Logical errors; II System errors. (4 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions

Question

c. What type of degree does it offer?

Answered: 1 week ago

Question

Always have the dignity of the other or others as a backdrop.

Answered: 1 week ago