« previous next »

Author Question: Copies of each database record or page before being changed by a transaction that are saved for use ... (Read 73 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?

In most climates, 8 to 10 glasses of water per day is recommended for adults. The best indicator for adequate fluid intake is frequent, clear urination.

Did you know?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

Did you know?

Persons who overdose with cardiac glycosides have a better chance of overall survival if they can survive the first 24 hours after the overdose.

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?

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.

Photosynthetic Organisms Changed Earth's Atmosphere Photosynthetic Organisms Changed Earth's Atmosphere
Harlem’s Promise Academy has a record of graduating and sending to college more than 90 percent ... Harlem’s Promise Academy has a record of graduating and sending to college more than 90 percent ...
An overlapping record extends back thousands of years of tree ring width An overlapping record extends back thousands of years of tree ring width
Page 3 Page 3
A gene map for chromosome 12 from the NCBI database Map Viewer A gene map for chromosome 12 from the NCBI database Map Viewer
An inventory record sheet shows a balance on hand of 972. During the month units sold were 111, ... An inventory record sheet shows a balance on hand of 972. During the month units sold were 111, ...
Video: Muscle Fatigue and Recovery

For a complete list of videos, visit our video library