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 129 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?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Did you know?

The first war in which wide-scale use of anesthetics occurred was the Civil War, and 80% of all wounds were in the extremities.

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

Did you know?

You should not take more than 1,000 mg of vitamin E per day. Doses above this amount increase the risk of bleeding problems that can lead to a stroke.

Results from sequential study of two cohorts tested at three ages and at three different points in t Results from sequential study of two cohorts tested at three ages and at three different points in t
Draw and label a diagram and explain how a factor-dependent transcription (rho-dependent) terminator Draw and label a diagram and explain how a factor-dependent transcription (rho-dependent) terminator
The material safety data sheet (MSDS) for sulfuric acid showing the detailed technical information ... The material safety data sheet (MSDS) for sulfuric acid showing the detailed technical information ...
Middle adults usually have more time to focus attention on their relationships Middle adults usually have more time to focus attention on their relationships
Social scientists have not done well at devising theories to explain lovely romantic moments Social scientists have not done well at devising theories to explain lovely romantic moments
Time-of-entry mapping Time-of-entry mapping
Video: Lipid digestion - mouth, stomach and small intestine

For a complete list of videos, visit our video library