g part 2: designing a dimensional (star) model and include the following: design the dimensions and the fact load the dimensions and the fact with relevant data from the operational database you designed in part 1, making sure to capture all of the queries. write a query in sql to get the quantities of the sold products on wednesday in the category footwear provided by vendor pacific gear within the tristate region between the 1st and the 2nd quarter of 2013. capture the query and the results.

Answers

Answer 1

The dimensional model for this question would include three dimensions: Products, Time, and Vendors.

The Product dimension would include data about the type of product, such as category, style, and size, as well as a measure for quantity. The Time dimension would include data about the day and quarter of the sale. The Vendor dimension would include data about the vendor, such as region and name.

The fact table would include the following measures: Quantity Sold, Price, and Discount.

The following SQL query can be used to get the quantities of the sold products on Wednesday in the category footwear provided by vendor Pacific Gear within the tristate region between the 1st and the 2nd quarter of 2013:

SELECT SUM(Quantity Sold)

FROM Fact_Table

WHERE Product.Category = 'Footwear'

AND Vendor.Name = 'Pacific Gear'

AND Vendor.Region = 'Tristate'

AND Time.Day = 'Wednesday'

AND Time.Quarter BETWEEN '1st' AND '2nd'

AND Time.Year = '2013';

For more questions like SQL query  click the link below:

https://brainly.com/question/28434444

#SPJ4


Related Questions

pls asap Casey's teacher needs to give him feedback on his history essay, including about his grammar and spelling. What's the MOST likely way they'll deliver this feedback?

Question 1 options:

by writing comments on his paper


by verbally telling him all the things they found wrong


by creating a memo about the changes


by sending him a text

Answers

The most likely way Casey's teacher will deliver feedback on his history essay, including about his grammar and spelling, is by writing comments on his paper.

Write a short note on grammar.

Grammar refers to the rules and principles that govern the structure and use of language. It encompasses various elements such as syntax, semantics, and morphology, and includes rules related to word order, sentence structure, and punctuation. Proper grammar is important for effective communication as it helps to convey meaning clearly and accurately.

Good grammar is important in both written and spoken communication. In written communication, grammar errors can make text difficult to understand or even change the meaning of a sentence. In spoken communication, grammar errors can make it difficult for listeners to understand what is being said or can make the speaker sound unprofessional.

Grammar is a skill that can be improved through practice and study. There are many resources available for learning and improving grammar, including books, online courses, and tutoring services. Improving grammar can help individuals communicate more effectively in various settings, including academic, professional, and personal contexts.

To learn more about grammar, visit:

https://brainly.com/question/1952321

#SPJ1

Consider the following static method, calculate.

public static int calculate(int x)
{
x = x + x;
x = x + x;
x = x + x;

return x;
}
Which of the following can be used to replace the body of calculate so that the modified version of calculate will return the same result as the original version for all values of x?

return 8 * x;
return 3 + x;
return 3 * x;
return 6 * x;
return 4 * x;

Answers

Answer:

return 8 * x;

Explanation:

Required

What can replace the three lines of x = x + x

We have, on the first line:

\(x=>x +x\)

\(x=>2x\)

On the second line:

\(x=>x +x\)

\(x=>2x\)

Recall that, the result of line 1 is: \(x=>2x\)

So, we have:

\(x=>2 * 2x\)

\(x=>4x\) --- at the end of \(line\ 2\)

On the third line:

\(x=>x +x\)

\(x=>2x\)

Recall that, the result of line 2 is: \(x=>4x\)

So, we have:

\(x = 2 * 4x\)

\(x => 8x\)

So: 8 * x can be used

which of the following uses technical and artistic skills to create visual products that communicate information to an audience? ○computer engineer ○typography ○computer animator ○graphic designer​

Answers

Answer:

grafic desiner

Explanation:

just a guess lol

Answer:

I don't know...

Explanation:

D

True or , false primary sources may contain data material. We now know is an accurate including personal beliefs, and bias is not intended to be openly published.

Answers

The answer is True.


Which is the best defense against ESD?
< Prev
Stand-off on motherboard
ZIF socket
Ground strap

Answers

The best defense against ESD is known to be called Ground strap.

What does grounding strap mean?

The ground strap is known to be a term that connote the grounding connection that tends to runs from a vehicle's engine to the area of  the negative battery terminal or that of the chassis.

Note that in the case above, both the negative battery terminal as well as the chassis of a said vehicle are known to be grounded.

Therefore, based on the above, one can say that the best defense against ESD is known to be called Ground strap.

Learn more about Ground strap from

https://brainly.com/question/14989495

#SPJ1

What are the types of control structures in algorithms and flowcharts?

Answers

Answer:

The following are the different types of control structures: Sequential control structure. Selection control structure. Iteration control structure.

pls give me

brainlistttt

a triangular number is a number that is the sum of the integers from 1 to some integer n. thus 1 is a triangular number because it is the sum of the integers from 1 to 1; 6 is a triangular number because 1 + 2 + 3 = 6.given the non-negative integer n, create a list of the first n triangular numbers. thus if n was 5, the list would be: {1, 3, 6, 10, 15}.assign the list to variable traingulars

Answers

Answer:

def triangular_numbers(n):

triangulars = []

sum = 0

for i in range(1, n+1):

sum += i

triangulars.append(sum)

return triangulars

# Test the function

print(triangular_numbers(5)) # Output: [1, 3, 6, 10, 15]

Explanation:

To create a list of the first n triangular numbers, you can use a for loop to iterate from 1 to n, and for each iteration, add the current number to the sum of the previous numbers.

This function will create a list of the first n triangular numbers and return it. You can then assign the returned list to the variable triangulars.

Delivery delays are caused by all of the following factors except:

Delivery delays are caused by all of the following factors except:

Answers

Using inventory best practices…

Delivery delays are caused by all the following factors except using inventory best practices, such as safety stock inventory or cross-docking. Thus, option A is correct.

What is a Delivery?

The delivery of the product can be done with the help of transportation which can be via various means like railways, roadways, waterways and various other means. The product can be delivered through multiway.

The delivery can be delayed in various ways making the stock or the inventory in the way may be due to stocking of the goods and also because of inventory control.

The exception of employing inventories guidelines like safeguard asset tracking or merge results in late deliveries. Whenever you are conscious of the type of inventory, you can regulate it and administer it more effectively.

Therefore, option A is the correct option.

Learn more about delivery , here:

https://brainly.com/question/28179832

#SPJ2

A blueprint or a "print" needs to
O be printed on blue paper
be a photograph
have enough information to build something
O be printed on both sides of the paper

Answers

Have enough information to build something

For current events, what type of sources would we use to learn about them?

A”Scholarly journals

B”News sources (broadcast, web, print)

C”Books

D”Reference works (encyclopedias, almanacs, etc.)

For current events, what type of sources would we use to learn about them?AScholarly journalsBNews sources

Answers

Answer:

B. News Sources (broadcast, web, print)

Explanation:

To learn about current events the most ideal sources of reference are News sources, either broadcast, web or print.

For example, if you're seeking breaking news or stories that are developing in the business world, the following sources are News sources you can turn to as sources of reference: CNN Business, Forbes, Bloomberg's Business Week, Fortune and other relevant Business News Media outfits.

3
Drag each label to the correct location on the image.
Pauline has decided that she wants to work in public relations, but she wants to work in the nonprofit sector. Help her decide which organizations to
shortlist by categorizing the organizations as commercial or nonprofit
All rights reserved
hotels
restaurants convention and visitors bureaus
information kiosks
Commercial Sector
airlines travel agencies
Nonprofit Sector

Answers

To categorize the organizations as commercial or nonprofit for Pauline's shortlisting in the public relations field, we can place the labels accordingly:

Commercial Sector:

- hotels

- restaurants

- convention and visitors bureaus

- information kiosks

- airlines

- travel agencies

Nonprofit Sector:

- All rights reserved

In the commercial sector, hotels, restaurants, convention and visitors bureaus, information kiosks, airlines, and travel agencies are profit-oriented businesses that operate in various industries. These organizations aim to generate revenue and maximize profitability through their products or services.

On the other hand, the label "All rights reserved" suggests an indication of copyright ownership or intellectual property protection, which is not directly related to a specific sector or organization type. Therefore, it does not fall into either the commercial or nonprofit sector category.

In Pauline's case, as she wants to work in public relations within the nonprofit sector, she should focus on shortlisting organizations that fall under the nonprofit sector. These could include charitable organizations, foundations, non-governmental organizations (NGOs), advocacy groups, or community-based organizations that operate with a mission to serve the public good rather than pursuing profits.

By categorizing organizations as commercial or nonprofit, Pauline can streamline her job search and target her efforts towards the specific sector that aligns with her career goals in public relations within the nonprofit realm.

For more such questions on commercial, click on:

https://brainly.com/question/1432446

#SPJ8

The dealer’s cost of a car is 85% of the listed price. The dealer would accept any offer that is at least $500 over the dealer’s cost. Design an algorithm that prompts the user to input the list price of the car and print the least amount that the dealer would accept for the car. C++

Answers

Here is an algorithm in C++ that prompts the user to input the list price of the car and prints the least amount that the dealer would accept for the car:

#include <iostream>

using namespace std;

int main() {

   double list_price, dealer_cost, min_accepted_price;

   const double DEALER_COST_PERCENTAGE = 0.85;

   const double MIN_ACCEPTED_PRICE_OVER_COST = 500;

   cout << "Enter the list price of the car: ";

   cin >> list_price;

   dealer_cost = list_price * DEALER_COST_PERCENTAGE;

   min_accepted_price = dealer_cost + MIN_ACCEPTED_PRICE_OVER_COST;

   cout << "The least amount the dealer would accept for the car is: $" << min_accepted_price << endl;

   return 0;

}

The algorithm starts by including the library iostream and declaring the namespaces. Then it declares the variables that will be used in the program (list_price, dealer_cost, min_accepted_price) and the constants that will be used (DEALER_COST_PERCENTAGE and MIN_ACCEPTED_PRICE_OVER_COST). Then it prompts the user to enter the list price of the car. Next, it calculates the dealer's cost by multiplying the list price by the dealer cost percentage and the minimum amount the dealer would accept by adding the dealer's cost to the minimum accepted price over cost. Finally, it prints the least amount the dealer would accept for the car.

3. Consider the organization you are currently working in and explain this organization from systems characteristics perspectives particularly consider objective, components (at least three) and interrelationships among these components with specific examples.

Answers

The organization i worked for from systems characteristics perspectives is based on

Sales and OperationsMarketing and Customer Relations

What is the  systems characteristics perspectives

In terms of Sales and Operations: This part involves tasks connected to managing inventory, moving goods, organizing transportation, and selling products. This means getting things, storing them,  sending them out, and bringing them to people.

Lastly In terms of  Marketing and Customer Relations: This part is all about finding and keeping customers by making plans for how to sell products or services.

Read more about  systems characteristics perspectives here:

https://brainly.com/question/24522060

#SPJ1

examples of main functions of a computer

Answers

Answer:

The main functions of a computer mainly includes the following: taking input data, processing the data, returning the results, and storing the data.

Explanation:

The 4 main functions of a computer are input, process, output, and storage. There are 5 main hardware components in a computer system: Input, Processing, Storage, Output and Communication devices.

we can change into another program by pressing..............?

Answers

Answer:

What software is it?

Explanation:

How could this code be simplified ​

How could this code be simplified

Answers

Answer:

D

Explanation:

by using for loop because its repeating alot and stuff yk

Help me with this digital Circuit please

Help me with this digital Circuit please
Help me with this digital Circuit please
Help me with this digital Circuit please
Help me with this digital Circuit please

Answers

A subset of electronics called digital circuits or digital electronics uses digital signals to carry out a variety of tasks and satisfy a range of needs.

Thus, These circuits receive input signals in digital form, which are expressed in binary form as 0s and 1s. Logical gates that carry out logical operations, including as AND, OR, NOT, NANAD, NOR, and XOR gates, are used in the construction of these circuits.

This format enables the circuit to change between states for exact output. The fundamental purpose of digital circuit systems is to address the shortcomings of analog systems, which are slower and may produce inaccurate output data.

On a single integrated circuit (IC), a number of logic gates are used to create a digital circuit. Any digital circuit's input consists of "0's" and "1's" in binary form. After processing raw digital data, a precise value is produced.

Thus, A subset of electronics called digital circuits or digital electronics uses digital signals to carry out a variety of tasks and satisfy a range of needs.

Learn more about Digital circuit, refer to the link:

https://brainly.com/question/24628790

#SPJ1

In a user interface, a screen is best understood as
A.a console


b.a variable


c.an input


d. an element

Answers

Answer:

d. an element

Explanation:

User Interface design is simply the designs that are used to model a product like an application.

In a user interface, a screen is best understood as an element.

Which of the following statements about memory is correct?

Answers

About what ask me if u need help
please attach the statements

Which type of query enables a user to move, append, or update matching records in a table?
action query
select query
static query
parameter query

Answers

Answer:

the query that allows these things is called an action query

Answer:

The answer is A-action query just finshed the review on edg 2021

Explanation:

How do you get a branliest answer?

Answers

Answer: You can achieve branliest by answering question correctly and to the satisfaction of the questioner. The best way to do this is by only answering questions that you are sure you know the answer to.

Explanation:

Hope I Helped!

To give branliest click the crown icon next to comments... and please give me branliest

Answer: You can get Branliest by writing the correct answer to questions

_________________ schedules the processor giving preference to the job with the shortest execution time.

Answers

Answer:

SJF

Explanation:

SJF is an acronym for the word, Shortest Job First. It is a scheduling algorithm that dies exactly what the question asked i.e, scheduling the processors by giving a much higher preference to jobs that posses the most little, or the shortest time of execution. It also brings down the usual waiting time for other processes that are for whatever reasons, yet to be executed.

How do I determine the size of my array in C?

Answers

Answer:

In C, you can use the sizeof operator to determine the size of an array. For example, if you have an array named myArray, you can determine its size with the following code:

int arraySize = sizeof(myArray) / sizeof(myArray[0]);

Explanation:

This will give you the number of elements in the array. Keep in mind that sizeof returns the size of the array in bytes, so you need to divide by the size of a single element in the array (which is given by sizeof(myArray[0])) to get the number of elements.

What is system analysis and design?

Answers

Answer:

According to the Merriam-Webster dictionary, studying an activity (such as a procedure, a business, or a physiological function) typically by mathematical means in order to define its goals or purposes and to discover operations and procedures for accomplishing them most efficiently"

According to the freedictonary, "the preparation of an assembly of methods, procedures, or techniques united by regulated interaction to form an organized whole".

This diagram shows who is responsible in preventing cyberbullying.
A flowchart.
Top box is labeled Cyberbullying can be prevented!
A line leads to two boxes labeled Parents/guardians, Schools.
Lines lead from Schools to boxes labeled Administrators, Teachers, Students.
Based on the diagram, which explains the most effective way to stop cyberbullying?

Answers

Answer:

Parents monitor home computer use, administrators secure school computers, and students report cyberbullying.

Explanation:

this should be right

Which of the following statements is true concerning the Internet of Things (IoT)? Wearable technologies are the only devices that currently connect to the Internet of Things. IoT is not affecting many businesses and the products they offer. Growth is expected to slow down over the next five years. IoT technology is relatively new and is expanding exponentially.

Answers

Answer:

i was looking and i think the answer would be growth slowing down but i might be wrong

Explanation:

Which of the following statements is true concerning the Internet of Things IoT is that the technology is relatively new and is expanding exponentially.

The IoT is regarded as a large network of connected things and individual. They collect and share data about the way they are used and about the environment around them.

It is aimed to connect all potential objects to interact each other on the internet to provide secure and a more comfort life for people.

The future of IoT has the prediction to be limitless with great advances and the industrial internet will be accelerated.

Conclusively, the Internet of Things (IoT) connect the world together.

Learn more from

https://brainly.com/question/14397947

Cathy O'Neal refers to the practice of pursuing the perpetrators of minor crimes as "zero
tolerance" - what is the importance of the establishment of this policing strategy for the
building of tools to predict crime hot spots?

Answers

Answer:

Supporting the Establishment of Predictive Policing Processes . ... Crime Hot Spots in Richmond, Virginia, 8:00 p.m.–12:00 a.m.................. 48. 2.11. Trends ... Using a Risk Terrain Analysis Tool to Predict Purse Snatching Risk ............ 54 ... For a policing strategy to be considered effective, it must produce tangible results. The.

is this helpful if it is can  you give brainlest

Explanation:

Doors and windows are important compositional elements that impact the facade of a building True False​

Answers

Answer:

true

Explanation:

Write a public static method named insert. The insert method should have the signature insert(String[] words, String newWord, int place), should return a String and should insert a string into the array replacing the string that was in place when called

Answers

Methods are group of code segments that are executed when evoked or called is in explanation part.

What is programming?

Making a set of instructions that instruct a computer how to carry out a task is the process of programming. Computer programming languages like JavaScript, Python, and C++ can all be used for programming.

The public static method named insert is:

public static boolean insert(String[] words, String newWord, int place) {

  if (place > words.length) {

      return false;

  }  

  else {

      for (int i = words.length - 1; i >= 0; i--) {

          if (place == i) {

              words[i] = newWord;

              break;

          } else {

              words[i] = words[i-1];

          }

      }

      return true;

  }

}

Thus, this is the program for the given scenario.

For more details regarding programming, visit:

https://brainly.com/question/11023419

#SPJ1

Your question seems incomplete, the probable complete question is:

Write a public static method named insert. The insert method should have the signature insert(String[] words, String newWord, int place), should return a boolean, and should function as described below.

When called, if place does not represent a valid index for words, then the method will return false to indicate the insertion could not be performed and do nothing else. Otherwise the method will insert the String newWord into the array words at the index place, moving each subsequent entry one place further and losing the final String in the array. The method will then return true to indicate the insertion has taken place.

Use the runner class to test this method: do not add a main method to your code in the U6_L4_Activity_One.java file or it will not be scored correctly.

Here is the runner code:

import java.util.Scanner;

public class runner_U6_L4_Activity_One{

public static void main(String[] args){

Scanner scan = new Scanner(System.in);

System.out.println("Enter array length:");

int len = scan.nextInt();

scan.nextLine();

String[] wordList = new String[len];

System.out.println("Enter values:");

for(int i = 0; i < len; i++){

wordList[i] = scan.nextLine();

}

System.out.println("Enter new String:");

String insWord = scan.nextLine();

System.out.println("Enter place:");

int pos = scan.nextInt();

System.out.println("Method return: " + U6_L4_Activity_One.insert(wordList, insWord, pos));

System.out.print("Array contents: {");

for(int i = 0; i < len-1; i++){

System.out.print(wordList[i] + ", ");

}

System.out.println(wordList[len-1]+"}");

}

}

5-5. Design an Ethernet network to connect a single client P C to a single server. Both the client and the server will connect to their workgroup switches via U T P. The two devices are 900 meters apart. They need to communicate at 800 M b p s. Your design will specify the locations of any switches and the transmission link between the switches.


5-6. Add to your design in the previous question. Add another client next to the first client. Both connect to the same switch. This second client will also communicate with the server and will also need 800 M b p s in transmission speed. Again, your design will specify the locations of switches and the transmission link between the switches.

Answers

Answer:

ok so u have take the 5 and put 6

Explanation:

5-5. Ethernet network design: UTP connections from client PC and server to workgroup switches, 900m fiber optic link between switches, 800 Mbps communication.

5-6. Additional client connects to the same switch, UTP connection, maintains existing fiber optic link, 800 Mbps communication with the server.

What is the explanation for this?

5-5. For connecting a single client PC to a single server, both located 900 meters apart and requiring communication at 800 Mbps, the following Ethernet network design can be implemented:

- Client PC and server connect to their respective workgroup switches via UTP.

- Use fiber optic cables for the 900-meter transmission link between the switches.

- Install switches at the client PC and server locations.

- Ensure that the switches support at least 1 Gbps Ethernet speeds to accommodate the required transmission speed.

5-6. In addition to the previous design, for adding another client next to the first client:

- Connect both clients to the same switch.

- Use UTP cables to connect the second client to the switch.

- Ensure the switch supports 1 Gbps Ethernet speeds.

- Maintain the existing fiber optic transmission link between the switches.

- The second client can also communicate with the server at the required 800 Mbps transmission speed.

Learn more about Network Design at:

https://brainly.com/question/7181203

#SPJ2

Other Questions
An NMOS anor for which mV 2 and VI-035 Vis operated with VOS VOS06V To wat value can VDS be reduced while maintaining the current unchanged Expres your answer in V list the next four multiples of each fraction 1/4 A gas has a pressure of 700. mmhg when the temperature is 107 c. at what temperature (in c) will the pressure be 600. mmhg, if there is no change in volume or amount of gas? What are the approaches companies use in implementing quality control policies Which of the following would be an advantage of Lenny running the team as a sole-proprietorship?(1) he would have more flexibility to run the team than with other types of business organizations(2) he would assume all of the profits of the team(3) any taxes on profits made from the team would be reported on lenny's personal tax returnIf Lenny owned the team as a sole proprietorship, which of the following is correct?if there was a tort lawsuit arisi The Chihuahuan Desert of the United States and Mexico may be the most biologically diverse desertin the world. Extensive grazing has caused the flora and soil of this ecosystem to become unstable.How has biodiversity affected the sustainability of this ecosystem?A Biodiversity has put this ecosystem at risk of being less sustainable in the future.B Biodiversity has not changed this ecosystem's level of sustainabilityC Biodiversity has prevented this ecosystem from being sustainable.D Biodiversity has helped this ecosystem remain sustainable.OAOBOD Find the values of a, b, and c such that the equation y=ax2+bx+c has ordered pair solutions (1,16), (1,2), and (0,1). To do so, substitute each ordered pair solution into the equation. Each time, the result is an equation in three unknowns, a, b, and c. Then solve the resulting system of three linear equations in three unknowns, a, b, and c. The table of values represents a polynomial function f(x)x f(x)4 3585 6906 11787 18528 27429 3878How much greater is the average rate of change over the interval [6,8] than the interval [5,7]? On January 1, 2018, Pomegranate Company acquired 90% of the voting stock of Starfruit Company for $91,700,000 in cash. The fair value of the noncontrolling interest in Starfruit at the date of acquisition was $6,300,000. Starfruits book value was $13,000,000 at the date of acquisition. Starfruits assets and liabilities were reported on its books at values approximating fair value, except its plant and equipment (10-year life, straight-line) was overvalued by $25,000,000. Starfruit Company had previously unreported intangible assets, with a market value of $40,000,000 and 5-year life, straight-line, which were capitalized following GAAP.Additional informationPomegranate uses the complete equity method to account for its investment in Starfruit on its own books. Goodwill recognized in this acquisition was impaired by a total of $2,000,000 in 2018 and 2019, and by $500,000 in 2020. It is now December 31, 2020, the accounting year-end. Here is Starfruit Companys trial balance at December 31, 2020: Dr (Cr)Current assets $28,200,000Plant & equipment, net 188,000,000Intangibles 2,000,000Liabilities (180,000,000)Capital stock (1,000,000)Retained earnings, January 1(29,500,000)Acumulated other comprehensive income, January 1(500,000)Dividends 400,000Sales revenue (24,000,000)Cost of goods sold 10,000,000Operating expenses 6,500,000Other comprehensive income (100,000)On the 2020 consolidated income statement, the noncontrolling interest in net income of Starfruit is:________.a. $150,000b. $175,000c. $200,000d. $750,000 john is currently on trial for murder. his attorney can raise the issue of his competence at any point in the adjudicative process What is the surface are of the figure? What does it mean if salmon is seared? Find the whole number equal to the fraction below. Enter your answer in the space provided. 21 /3 Henry VIII did not start the Protestant Reformation, but his divorce fueled it.O TrueO False the neurotransmitter is secreted by the neurons of the basal nuclei. the degeneration of these neurons results in disease. Working from home has the potential to affect rural areas. What are the main opportunities? What are the main challenges? Briefly explain. Ashya wants to focus on the diagnosis and treatment of psychological disorders and other problematic patterns of behavior. what area of psychology should she work in? group of answer choices Hangovers, interference with hormones, adding excess calories, and displacing healthier food choices from your diet include consequences of what is the chemical formula for dinitrogen tetroxide? The hottest and largest stars, __________, take the __________ amount of time to form, and have the __________ life span.A.O-type; longest; longestB.M-type; longest; longestC.O-type; shortest; shortestD.M-type; longest; shortestE.M-type; shortest; shortestF.O-type; longest; shortest