This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Explain the term time-variant in the following data warehouse definition:The data warehouse is a ... (Read 189 times)

kwoodring

  • Hero Member
  • *****
  • Posts: 560
on: Jul 7, 2018
Explain the term time-variant in the following data warehouse definition:The data warehouse is a structured repository of integrated, subject-oriented, enterprise-wide, historical, and time-variant data.
 
  The purpose of the data warehouse is the retrieval of analytical information. A data warehouse can store detailed and/or summarized data.

Question 2

Table ENROLLMENT is:
 
  A) Not in 1NF
  B) In 1NF but not in 2NF
  C) In 2NF but not in 3NF
  D) In 3NF


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

nmyers

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

The term time-variant refers to the fact that a data warehouse contains slices or snapshots of data from different periods of time across its time horizon. With these data slices, the user can create reports for various periods of time within the time horizon. For example, if the subject of analysis is cost and the time horizon is a number of years, we can analyze and compare the cost for the first quarter from a year ago versus the cost for the first quarter from two years ago.

Answer to Question 2

C


kwoodring

  • Hero Member
  • *****
  • Posts: 560
Reply #2 on: Jul 7, 2018
Thank you :)


nmyers

  • Sr. Member
  • ****
  • Posts: 336
Reply #3 on: Jul 7, 2018
Happy to help you


« previous next »
 

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

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?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

Alcohol acts as a diuretic. Eight ounces of water is needed to metabolize just 1 ounce of alcohol.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

The geomagnetic polarity time scale shows how Earth’s magnetic pole has changed through geologic tim The geomagnetic polarity time scale shows how Earth’s magnetic pole has changed through geologic tim
Remedies for insomnia include increased physical exercise and time spent outdoors. Remedies for insomnia include increased physical exercise and time spent outdoors.
Alternative methods for locating the CPT Main Term. Alternative methods for locating the CPT Main Term.
Material safety data sheets (MSDS), now called safety data sheets (SDS), should be readily available ... Material safety data sheets (MSDS), now called safety data sheets (SDS), should be readily available ...
Part of a Semantic Network in Long-Term Memory Part of a Semantic Network in Long-Term Memory
No payments were made on a $2,598 loan during its three-year term. What was the annually ... No payments were made on a $2,598 loan during its three-year term. What was the annually ...
Video: Vascular tissues in a corn stem and a buttercup root

For a complete list of videos, visit our video library