Question

In: Computer Science

SQL Consider the following business question and determine which of the following should be included in...

SQL

Consider the following business question and determine which of the following should be included in a fact/dimension table of the star schema

What was the revenue of the McDonald’s in Russia and France in 2017?

A. Russia

B. France

C. Revenue

D. Countries

Answer for both Fact and Dimension tables.

Please determine from the question which is part of the fact, and which is part of the dimension. There should be two answers.

Expert Solution

A. Star Schema may look like below diagram

As per the structure of Star Schema, Fact would be Revenue and Dimensions would be Russia, France and Countries.

Explanation :- Mostly Fact tables contains the more aggregated and Amount columns. So in our case Fact is revenue. Where as in Dimensions we keep more detailed information related to Products, Sales Organization, Countries, Customer and more of descriptive information. Means in our case France,Russia and Countries.

B. Table Structure Would look Like below Diagram

##Revenue amount of McDonald's in 2017 in France and Russia.

select sum(r.Net_Amount) from Revenue r

left outer join Countries c on r.storeID=c.storeID

where c.country in ('France','Russia')

and year(r.date)=2017

venereology answered 2 hours ago

Need SQL Tables Final Project should be included ER, NER, Table diagrams and SQL statements. The...

Need SQL Tables Final Project should be included ER, NER, Table diagrams and SQL statements. The final project is about developing an auction Web site. The details are as follows: BA is an online auction Web site. People can buy and sell items in this Web site. Buyers are people who like to buy items, and sellers are people who like to sell items. •Each seller can sell items. •Each item has a bidding start time, an end time, and...

Which of the following is not included as one of the items that the design must determine

Which of the following is not included as one of the items that the design must determine a) The number of factors to include in the experiment b) The levels at which each factor will be tested c) The response variable d) The design repot distribution e) The conditions (settings) for each trial

Write an evidence-based response to each question below. ● Determine what should be included in client...

Write an evidence-based response to each question below. ● Determine what should be included in client and family teaching that reflects principles associated with the following. ○ Informed consent ○ Refusal of treatment ○ Advance directives

Which of the following should be included in the analysis of a project? (mark all that...

Which of the following should be included in the analysis of a project? (mark all that apply) Finance cost. opportunity cost. sunk costs. erosion costs.

Which of the following items should be included in the value of the land Tax and...

Which of the following items should be included in the value of the land Tax and title costs All of these items should be included in the value of the land Clearing of the land for use Cash price of the land

Which of the following should NOT be included as part of manufacturing overhead at a company...

Which of the following should NOT be included as part of manufacturing overhead at a company that makes office furniture? [[selectone]] a. Idle time for direct labor. b. Sheet steel in a file cabinet made by the company. c. Manufacturing equipment depreciation. d. Taxes on a factory building.

Which of the following are not examples of directly attributable costs that should be included in...

Which of the following are not examples of directly attributable costs that should be included in the cost of acquisition for property, plant and equipment? Select one: a. Costs of opening a new facility. b. Initial delivery and handling costs c. Costs of site preparation d. Installation and assembly costs Property, plant and equipment includes items that: Select one: a. have no physical substance. b. are expected to be used up within one year from date of purchase. c. held...

Which of the following should be included in a project charter? A. Title and objective B....

Which of the following should be included in a project charter? A. Title and objective B. Funding and major risks C. Milestone schedule and key deliverables D. Key assumptions and constraints E. Approval and reporting requirements F. All of the above

56. Which of the following should NOT be included in the cover letter you send to...

56. Which of the following should NOT be included in the cover letter you send to an organization along with your résumé? A. description of your ability to meet the needs of the company highlights about one or two of your accomplishments relevant to the specific job you're applying for a request for an interview a list of all your major accomplishments

Which of the following questions should Brian consider to determine whether his paragraphs are well- developed?...

Which of the following questions should Brian consider to determine whether his paragraphs are well- developed? A. Did he use figurative language? B. Did he use descriptive language? C. Did he provide sufficient evidence to achieve his purpose? D. Did he use a confident tone?