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

laurencescou

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

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

Did you know?

The heart is located in the center of the chest, with part of it tipped slightly so that it taps against the left side of the chest.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

Human kidneys will clean about 1 million gallons of blood in an average lifetime.

For a complete list of videos, visit our video library