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 100 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
Wow, this really help

tandmlomax84

  • Member
  • Posts: 323
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

Did you know?

A strange skin disease referred to as Morgellons has occurred in the southern United States and in California. Symptoms include slowly healing sores, joint pain, persistent fatigue, and a sensation of things crawling through the skin. Another symptom is strange-looking, threadlike extrusions coming out of the skin.

Did you know?

About 100 new prescription or over-the-counter drugs come into the U.S. market every year.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

The Romans did not use numerals to indicate fractions but instead used words to indicate parts of a whole.

Fluorescence recovery after photobleaching (FRAP). Fluorescence recovery after photobleaching (FRAP).
Positioning and Draping Techniques Positioning and Draping Techniques
Specimen collection techniques Specimen collection 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.
Performing Transmission-Based Precaution: Isolation Techniques Performing Transmission-Based Precaution: Isolation Techniques
Simple Decorating Techniques: Stencils Simple Decorating Techniques: Stencils
Video: Structures that affect circulation - heart and MABP

For a complete list of videos, visit our video library