This topic contains a solution. Click here to go to the answer

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

09madisonrousseau09

  • Hero Member
  • *****
  • Posts: 559
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
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


bdobbins

  • Member
  • Posts: 326
Reply 3 on: Yesterday
Gracias!

 

Did you know?

Over time, chronic hepatitis B virus and hepatitis C virus infections can progress to advanced liver disease, liver failure, and hepatocellular carcinoma. Unlike other forms, more than 80% of hepatitis C infections become chronic and lead to liver disease. When combined with hepatitis B, hepatitis C now accounts for 75% percent of all cases of liver disease around the world. Liver failure caused by hepatitis C is now leading cause of liver transplants in the United States.

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

More than 2,500 barbiturates have been synthesized. At the height of their popularity, about 50 were marketed for human use.

Did you know?

Patients who have been on total parenteral nutrition for more than a few days may need to have foods gradually reintroduced to give the digestive tract time to start working again.

For a complete list of videos, visit our video library