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

In the United States, congenital cytomegalovirus causes one child to become disabled almost every hour. CMV is the leading preventable viral cause of development disability in newborns. These disabilities include hearing or vision loss, and cerebral palsy.

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

Liver spots have nothing whatsoever to do with the liver. They are a type of freckles commonly seen in older adults who have been out in the sun without sufficient sunscreen.

Attention and memory are in demand during circle time. Attention and memory are in demand during circle time.
With fewer men than women in college, is it time to consider affirmative action for men? With fewer men than women in college, is it time to consider affirmative action for men?
Three Pieces of the Long-Term Weight-Loss Puzzle Diet Three Pieces of the Long-Term Weight-Loss Puzzle Diet
Rockin' In Time, 9th Edition Rockin' In Time, 9th Edition
The TaqMan approach to quantitative real-time PCR (qPCR) The TaqMan approach to quantitative real-time PCR (qPCR)
Histograms - Analysis and Data Histograms - Analysis and Data
Video: Skin Cancer

For a complete list of videos, visit our video library