« previous next »

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

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

Critical care patients are twice as likely to receive the wrong medication. Of these errors, 20% are life-threatening, and 42% require additional life-sustaining treatments.

Did you know?

As of mid-2016, 18.2 million people were receiving advanced retroviral therapy (ART) worldwide. This represents between 43–50% of the 34–39.8 million people living with HIV.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Many medications that are used to treat infertility are injected subcutaneously. This is easy to do using the anterior abdomen as the site of injection but avoiding the area directly around the belly button.

A stallion with a proven competition record is one criterion for being a suitable sire. A stallion with a proven competition record is one criterion for being a suitable sire.
An example of a late entry to the medical record. An example of a late entry to the medical record.
Technology has changed our lives fundamentally. The connection to each telephone call used to have ... Technology has changed our lives fundamentally. The connection to each telephone call used to have ...
Record the AC frequency as shown on the meter and subtract 50 from the reading (e.g., 60.50 -50.00 = ... Record the AC frequency as shown on the meter and subtract 50 from the reading (e.g., 60.50 -50.00 = ...
Visual Elements of Pictorial Expression: A. Carpet Page from the Lindisfarne Gospels Visual Elements of Pictorial Expression: A. Carpet Page from the Lindisfarne Gospels
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: Major Elements in Biological Molecules: Proteins

For a complete list of videos, visit our video library