« previous next »

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

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

Certain rare plants containing cyanide include apricot pits and a type of potato called cassava. Fortunately, only chronic or massive ingestion of any of these plants can lead to serious poisoning.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

Every flu season is different, and even healthy people can get extremely sick from the flu, as well as spread it to others. The flu season can begin as early as October and last as late as May. Every person over six months of age should get an annual flu vaccine. The vaccine cannot cause you to get influenza, but in some seasons, may not be completely able to prevent you from acquiring influenza due to changes in causative viruses. The viruses in the flu shot are killed—there is no way they can give you the flu. Minor side effects include soreness, redness, or swelling where the shot was given. It is possible to develop a slight fever, and body aches, but these are simply signs that the body is responding to the vaccine and making itself ready to fight off the influenza virus should you come in contact with it.

Did you know?

Individuals are never “cured” of addictions. Instead, they learn how to manage their disease to lead healthy, balanced lives.

Vinyl record Vinyl record
Page from a copy of Nizami's Khamseh (Quintet) illustrating a princely country feast, Persian, ... Page from a copy of Nizami's Khamseh (Quintet) illustrating a princely country feast, Persian, ...
Johannes Gutenberg, Page from the Forty-Two-Line Bible, Mainz. Johannes Gutenberg, Page from the Forty-Two-Line Bible, Mainz.
One page of color vision chart. One page of color vision chart.
In the box on upward social mobility on page 82, we discussed how Latinos face a similar situation. ... In the box on upward social mobility on page 82, we discussed how Latinos face a similar situation. ...
The karyotype of a triploid individual contains three copies of each chromosome. The karyotype of a triploid individual contains three copies of each chromosome.
Video: Miller's reaction chamber experiment Animation

For a complete list of videos, visit our video library