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

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

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

Did you know?

About 60% of newborn infants in the United States are jaundiced; that is, they look yellow. Kernicterus is a form of brain damage caused by excessive jaundice. When babies begin to be affected by excessive jaundice and begin to have brain damage, they become excessively lethargic.

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
The carbon cycle. Numbers are storage as 1015 g or fluxes as 1015 g per year (data from Schlesinger The carbon cycle. Numbers are storage as 1015 g or fluxes as 1015 g per year (data from Schlesinger
Tracking time of marker entry generates a chromosome map Tracking time of marker entry generates a chromosome map
A full-term pregnancy. Image illustrates position of the fetus and the structures associated with pr A full-term pregnancy. Image illustrates position of the fetus and the structures associated with pr
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 ...
How to calculate the mean for grouped data How to calculate the mean for grouped data
The age-adjusted rate of melanoma, a deadly form of skin cancer, from 1973 to 2000. Over that time p The age-adjusted rate of melanoma, a deadly form of skin cancer, from 1973 to 2000. Over that time p
Video: Electrical Conduction System of the Heart

For a complete list of videos, visit our video library