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 113 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
:D TYSM

billybob123

  • Member
  • Posts: 336
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

Did you know?

Alcohol acts as a diuretic. Eight ounces of water is needed to metabolize just 1 ounce of alcohol.

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

Every flu season is different, and even healthy people can get extremely sick from the flu, as well as spread it to others. The flu season can begin as early as October and last as late as May. Every person over six months of age should get an annual flu vaccine. The vaccine cannot cause you to get influenza, but in some seasons, may not be completely able to prevent you from acquiring influenza due to changes in causative viruses. The viruses in the flu shot are killed—there is no way they can give you the flu. Minor side effects include soreness, redness, or swelling where the shot was given. It is possible to develop a slight fever, and body aches, but these are simply signs that the body is responding to the vaccine and making itself ready to fight off the influenza virus should you come in contact with it.

Did you know?

In 2006, a generic antinausea drug named ondansetron was approved. It is used to stop nausea and vomiting associated with surgery, chemotherapy, and radiation therapy.

An example of color blindness test. A person with red-green color blindness would not be able to dis An example of color blindness test. A person with red-green color blindness would not be able to dis
Techniques for Measuring Cosmological Distances Techniques for Measuring Cosmological Distances
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.
The level in the coolant recovery system raises and lowers with engine temperature. The level in the coolant recovery system raises and lowers with engine temperature.
Lymphatic massage techniques improve the circulation of lymph fluid. Lymphatic massage techniques improve the circulation of lymph fluid.
Fascial stretching techniques. (A) Cross-hand dual direction stretch. (B) Pin and stretch with the ... Fascial stretching techniques. (A) Cross-hand dual direction stretch. (B) Pin and stretch with the ...
Video: Hormonal regulation of pregnancy - weeks 17 through 38

For a complete list of videos, visit our video library