« previous next »

Author Question: Copies of each database record or page before being changed by a transaction that are saved for use ... (Read 36 times)

laurencescou

  • Hero Member
  • *****
  • Posts: 593
on: Jul 7, 2018
Copies of each database record or page before being changed by a transaction that are saved for use in database recovery are called before images.
 
  Indicate whether the statement is true or false

Question 2

Describe the steps in assessing table structure when you are given a set of tables and asked to construct a new database to store the existing data.
 
  What will be an ideal response?


blakcmamba

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

TRUE

Answer to Question 2

First, you should count the number of rows in the tables and determine the type of data stored in each column. Second, you should analyze the existing data values and work with users to determine (1 ) multivalued dependencies, (2 ) functional dependencies, (3 ) candidate keys, (4 ) primary keys and (5 ) foreign keys. Finally, you should check the validity of the possible referential integrity constraints.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

The largest baby ever born weighed more than 23 pounds but died just 11 hours after his birth in 1879. The largest surviving baby was born in October 2009 in Sumatra, Indonesia, and weighed an astounding 19.2 pounds at birth.

Did you know?

Many supplement containers do not even contain what their labels say. There are many documented reports of products containing much less, or more, that what is listed on their labels. They may also contain undisclosed prescription drugs and even contaminants.

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

An electrocardiogram (EKG) wave, a record of the electrical signal as it moves through the conductio An electrocardiogram (EKG) wave, a record of the electrical signal as it moves through the conductio
Modern primate study sometimes involves high-tech methods. This golden lion tamarin is having a batt Modern primate study sometimes involves high-tech methods. This golden lion tamarin is having a batt
An example of a late entry to the medical record. An example of a late entry to the medical record.
Radioactive protection services record book and two badge-style dosimeters. Radioactive protection services record book and two badge-style dosimeters.
TEEMID - Golden Record TEEMID - Golden Record
A karyotype shows this child has three copies of chromosome 21. A karyotype shows this child has three copies of chromosome 21.
Video: Power Supply Polyacrylamide Gel Protein Sample

For a complete list of videos, visit our video library