This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Distinguish between reprocessing and rollforward as database recovery techniques. What will be an ... (Read 34 times)

09madisonrousseau09

  • Hero Member
  • *****
  • Posts: 559
on: Jul 7, 2018
Distinguish between reprocessing and rollforward as database recovery techniques.
 
  What will be an ideal response?

Question 2

Distinguish between a data model and a database design.
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

strudel15

  • Sr. Member
  • ****
  • Posts: 324
Reply #1 on: Jul 7, 2018
Answer to Question 1

Reprocessing and rollforward both require the use of database saves, which are backups of the database at a known state. Reprocessing as a means of recovery involves recovering the database from the last database save and having the application programs reprocess all the transactions since the save. Rollforward as a means of recovery involves recovering the database from the last save and then reapplying all changes to the database. Reprocessing does not always reproduce the original database contents correctly since minute changes in processing by the application programs may result in changes in data manipulation.

Answer to Question 2

The data model is a representation of the content, relationships, and constraints of the data needed to support the users' requirements for the system. The data model is a logical representation of business requirements. The database design is created from the data model to include tables, relationships, constraints, data types, column properties, and descriptions of primary and foreign keys. The database design is a component design of how database technology can accomplish the support of the system requirements depicted in the data model.


09madisonrousseau09

  • Member
  • Posts: 559
Reply 2 on: Jul 7, 2018
Excellent

tranoy

  • Member
  • Posts: 344
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

The immune system needs 9.5 hours of sleep in total darkness to recharge completely.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

The term pharmacology is derived from the Greek words pharmakon("claim, medicine, poison, or remedy") and logos ("study").

Did you know?

The first oncogene was discovered in 1970 and was termed SRC (pronounced "SARK").

assessment techniques assessment techniques
The first step in field recovery involves surveying the site, sometimes with special equipment. The first step in field recovery involves surveying the site, sometimes with special equipment.
Intaglio printmaking techniques, side views. Intaglio printmaking techniques, side views.
Performing Transmission-Based Precaution: Isolation Techniques Performing Transmission-Based Precaution: Isolation Techniques
Metastatic spread of the tumor shown with imaging techniques. Metastatic spread of the tumor shown with imaging techniques.
Apply compression and light effleurage techniques to the foot and ankle to warm the area. Apply compression and light effleurage techniques to the foot and ankle to warm the area.
Video: How does an animal choose what food to eat?

For a complete list of videos, visit our video library