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

People who have myopia, or nearsightedness, are not able to see objects at a distance but only up close. It occurs when the cornea is either curved too steeply, the eye is too long, or both. This condition is progressive and worsens with time. More than 100 million people in the United States are nearsighted, but only 20% of those are born with the condition. Diet, eye exercise, drug therapy, and corrective lenses can all help manage nearsightedness.

Did you know?

When intravenous medications are involved in adverse drug events, their harmful effects may occur more rapidly, and be more severe than errors with oral medications. This is due to the direct administration into the bloodstream.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Did you know?

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

Did you know?

Barbituric acid, the base material of barbiturates, was first synthesized in 1863 by Adolph von Bayer. His company later went on to synthesize aspirin for the first time, and Bayer aspirin is still a popular brand today.

For a time Dr. Seuss—Theodor Seuss Geisel—drew political cartoons. This one, published in ... For a time Dr. Seuss—Theodor Seuss Geisel—drew political cartoons. This one, published in ...
Older adulthood can be a time of independence and exploration as responsibilities diminish and the ... Older adulthood can be a time of independence and exploration as responsibilities diminish and the ...
Apply circular friction and direct pressure to suboccipital muscles one side at a time.Turn head to ... Apply circular friction and direct pressure to suboccipital muscles one side at a time.Turn head to ...
The relationship between the permissible exposure limit (PEL), the short-term exposure limit (STEL), ... The relationship between the permissible exposure limit (PEL), the short-term exposure limit (STEL), ...
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 ...
Full-term Fetus Full-term Fetus
Video: Four Giant Convection Cells oF Earth

For a complete list of videos, visit our video library