This assignment uses a GCU-provided virtual machine that will be specified by your instructor.
Designing a dimensional (star) model involves considering which dimensions to use with the Fact table representing the chosen subject. The goal of this part is to design a dimensional (star) model for a data warehouse that enables analysis of sales by Product, Customer, Store, and Date.
View the "Data Warehouse" video within the "Video Playlist: Relational Databases for Business Applications," located in the topic Resources.
For this assignment, refer to the "SYM-408 Dimensional Diagram" document to complete the assignment.
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.
Generate 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

Three dimensions—Products, Time, and Vendors—would make up the physical model for this inquiry.

What else is SQL for total newbies?

A database's contents can be stored, modified, and retrieved using SQL, a standard language. Our SQL lesson will show you how to apply SQL in a variety of database systems, including MySQL, Mssql, MS Access, Mysql, Sybase, Informix, and Postgres. Learn SQL right away »

Briefing:

The quantity of the products sold on Thursday in the category of footwear offered by vendor Asian Gear in the tristate area between the first and second quarter of 2013 may be obtained using the SQL query below:

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';

To know more about SQL query visit:

https://brainly.com/question/28434444

#SPJ4

Related Questions

Write a method called allDigitsOdd that returns whether every digit of a positive integer is odd. Return true if the number consists entirely of odd digits (1, 3, 5, 7, 9) and false if any of its digits are even (0, 2, 4, 6, 8). For example, the call allDigitsOdd(135319) returns true but allDigitsOdd(9145293) returns false.

Answers

Answer:

Sample output:

Enter integer 3232423

true

Enter integer 12131231

false

Explanation:

Above is the output of the program and for the solution check the screenshots attach to understand clearly the program.

Thanks

Write a method called allDigitsOdd that returns whether every digit of a positive integer is odd. Return

1. What abstraction does an OS provide for the CPU?
2. What abstraction does an OS provide for the memory?
3. What abstraction does an OS provide for the disk space?

Answers

Abstraction refers to the process of removing elements of a code or program that are irrelevant or distract from more important elements.

What are the abstractions OS provides?By virtualizing the CPU, the operating system provides this abstraction. By running one process, then stopping it and starting another, and so on, the operating system can create the illusion of many virtual CPUs when there is only one physical CPU (or a few).A memory abstraction is a layer of abstraction between program execution and memory that provides a different "view" of a memory location depending on the execution context in which the memory access is performed.Many operating systems include a hardware abstraction layer, which eliminates the need to modify the OS kernel in order to run programs on computers with different hardware architectures. It is a device driver that allows programs to connect to hardware peripherals through a consistent interface.

To learn more about abstraction refer to :

https://brainly.com/question/25964253

#SPJ1

Which of the following is true?Select one:A. Frames are carried inside packets.B. Packets are carried inside frames.C. both Frames are carried inside packets and Packets are carried inside framesD. neither Frames are carried inside packets nor Packets are carried inside frames

Answers

Packets are carried inside the frame this is true among all

What are packets and frames?

The data unit used in the network layer is a packet, whereas the data unit used in the data link layer of the OSI model is a frame. Compared to a packet, a frame carries more details about the transmitted message. There are two different kinds of frames used in networking: fixed-length frames and variable-length frames.

In frames are carried packets. The network address and the link address are the two addresses that you should be aware of. The packet's network address serves as the final destination, according to the fundamental concept. This has universal significance and is constant.

Hence to conclude the packets are carried inside the frames

To know more on networking follow this link:

https://brainly.com/question/1027666

#SPJ4

2. To publish your slide show as movie what should you click on first? (1 point)
O File
O Animations
O Slide Show
O View

Answers

To publish your slide show as movie we click on Slide show first.

What do you know about PPT?

A PowerPoint slideshow (PPT) is a presentation made using Microsoft software that enables users to include audio, visual, and audio/visual features. It is regarded as a multimedia technology that also serves as a tool for sharing and collaborating on content.

What is Slide show?

A slide show (slideshow) is a presentation of a series of still images (slides) on a projection screen or electronic display device, typically in a prearranged sequence.

To start your slide show, on the Slide Show tab, select Play From Beginning.

To manage your slide show, go to the controls in the bottom-left corner

To skip to any slide in the presentation, right-click the screen and select Go to Slide. Then, enter the slide number you want in the Slide box, and select OK.

Learn more about SlideShow click here :

https://brainly.com/question/27363709

#SPJ1

Which TWO objects are likely to have SSD chips in them?
office access card
bank debit card
food service token
discount coupon
business card

Answers

Bank card and discount coupon

Answer:

Bank card and discount coupon

Explanation:

Suppose a friend gives you a computer, but when you try to start it, a message appears asking for a BIOS password. You can't contact the friend to find out the password. How should you proceed?

Answers

Answer:

Clear the CMOS

Explanation:

The CMOS stores the BIOS settings.

One lap around a standard high-school running track is exactly 0.25 miles. Write the function miles_to_laps() that takes a number of miles as an argument and returns the number of laps. Complete the program to output the number of laps.

Answers

def miles_to_laps(mi):

return f"{mi} mile(s) is {mi/0.25} lap(s)"

print(miles_to_laps(1))

I wrote my code in python 3.8. I hope this helps!

In a train stations database, an employee MUST be a train driver, ticket issuer or train attendant, with following constraint: Same employee cannot occupy more than one job type.
Draw EER diagram to represent specialization of employees in the train station database.

Answers

The EER diagram for the train station database can be represented as follows:

The EER diagram

+-------------------+

| Employee |

+-------------------+

| employee_id (PK) |

| name |

| address |

+-------------------+

+-------------+----------------+

| |

v v

+-------------------+ +-------------------+ +-------------------+

+-------------------+ +-------------------+ +-------------------+

+-------------------+ +-------------------+ +-------------------+

The given illustration features a fundamental element known as "Employee", which denotes every individual employed at the railway station.

The "Employee" object is equipped with features, like employee identification number, full name, and place of residence. The "Employee" entity gives rise to three distinct units, namely "Train Driver," "Ticket Issuer," and "Train Attendant. "

Every distinct entity has an attribute known as foreign key (employee_id) that refers to the main key of the "Employee" entity. Each distinct unit possesses distinct characteristics that are unique to their job category, such as license_number for Train Drivers, badge_number for Ticket Issuers, and uniform_size for Train Attendants.

Answers

Answer:

Explanation:

as binary search will search the array by dividing it into two halves till it find the value.

Write a program called DeliveryCharges for the package delivery service in Exercise 4. The program should again use an array that holds the 10 zip codes of areas to which the company makes deliveries. Create a parallel array containing 10 delivery charges that differ for each zip code. Prompt a user to enter a zip code, and then display either a message indicating the price of delivery to that zip code or a message indicating that the company does not deliver to the requested zip code.

Answers

Answer:

zip_codes = ["11111", "22222", "33333", "44444", "55555", "66666", "77777", "88888", "99999", "00000"]

charges = [3.2, 4, 1.95, 5.7, 4.3, 2.5, 3.8, 5.1, 6.6, 7.3]

deliver = False

index = -1

zip_code = input("Enter the zip code: ")

for i in range(len(zip_codes)):

if zip_code == zip_codes[i]:

deliver = True

index = i

break

if deliver:

print("The charge of delivery to " + zip_codes[index] + " is $" + str(charges[index]))

else:

print("There is no delivery to " + zip_code)

Explanation:

*The code is in Python.

Initialize the zip_codes array with 10 zip codes

Initialize the charges array with 10 corresponding values

Initialize the deliver as False, this will be used to check if the zip code is in the zip_codes

Initialize the index, this will be used if the zip code is a valid one, we will store its index

Ask the user to enter the zip_code

Create a for loop that iterates the length of the zip_codes array. Inside the loop:

Check if the zip_code is equal to the any of the items in the zip_codes. If it is, set the deliver as True, set the index as i, and break

When the loop is done, check the deliver. If it is True, then print the charge of the delivery. Otherwise, print that there is no delivery to that zip code

Tracy has completed installing Windows 7 on a computer and is ready to install a printer. Tracy attaches the printer to the computer and a message pops up that a new device is being installed. When the process is done, she tries to locate the printer, but the printer is not available.
What can Tracy do to use the printer?

Answers

[] Install the driver from the manufacturer's website.

Correct. Microsoft does not embed drivers for all devices. If a device will not work with the Windows drivers, Tracy should check for third-party drivers at the manufacturer's website.

What is printer?

A printer is a computer accessory which creates a permanent representation of text or graphics, typically on paper. Although the majority of output is understandable by humans, bar code printers are an example of a printer's wider application. 3D printers, inkjet printers, laser printers, and thermal printers are a few of the several types of printers. Charles Babbage created the first computer printer in the 19th century for his difference engine, but it wasn't until 2000 that his mechanical printer design was really implemented. In specifically, an electrostatic inking device and a method for electrostatically depositing ink on predetermined portions of a receiving media were the first printing mechanisms for applying a marking medium to a recording medium to be granted a patent, both by C. R. Winston in 1962.

To know more about printer visit:

https://brainly.com/question/28942240

#SPJ4

write about word processing software?
I.e about creating documents, editing documents and formatting documents

Answers

Word processing software is a computer program that allows users to create, edit, and format documents.

With word processing software, users can create professional-looking documents for a variety of purposes, such as reports, letters, resumes, and more.One of the main features of word processing software is the ability to create documents. Users can create a new document by opening the word processing program and choosing the option to create a new document. They can then enter text, images, tables, and other elements into the document as needed. Many word processing programs also provide templates that users can use as a starting point for their documents, which can help save time and ensure that the document is properly formatted.

Another important feature of word processing software is the ability to edit documents. Users can make changes to the content of their documents by inserting, deleting, or moving text and other elements. They can also use tools such as spell check and grammar check to help ensure that their documents are free of errors.

In addition to creating and editing documents, word processing software also allows users to format their documents. Formatting includes tasks such as setting margins, choosing font styles and sizes, and adding colors and backgrounds. Word processing software typically provides a wide range of formatting options, which can help users create visually appealing and professional-looking documents.

Overall, word processing software is an essential tool for creating, editing, and formatting documents. It is widely used in a variety of settings, including business, education, and personal use, and can help users produce high-quality documents efficiently and effectivel

To Learn More About Processing Software

https://brainly.com/question/29762855?referrer=searchResults

Explain why there are more general-purpose registers than special purpose registers.

Answers

Answer:

Explanation:

General purpose registers are used by programmer to store data whereas the special purpose registers are used by CPU for temporary storage of the data for calculations and other purposes.

tên trong pascal gồm những thành phần nào?

Answers

Explanation:

Pascal phân biệt ba loại tên: + Tên dành riêng: là tên được ngôn ngữ lập trình quy định dung với ý nghĩa riêng xác định. người lập trình không được sử dụng với ý nghĩa khác. Ví dụ (Trong pascal): program, uses, const, type, var, begin, end.

Four actions that can be implemented on a database to autocorrect violations of referential integrity, and the outcomes of the actions are listed below. Match the violation with the corrective action Instructions: Choose your responses from the drop-down menus below. Response options cannot be used more than once.
a. Sets invalid foreign keys to a default primary key value, specified in SQL
b. Propagates primary key changes to foreign keys
c. Rejects an insert, update, or delete
d. Sets invalid foreign keys to NULL
1. Restrict
2. Set Null
3. Set Default
4. Cascade

Answers

Answer:

Follows are the matching to this question:

$Option \ a \to \ Option \ 3\\\\Option \ b \to \ Option \ 4\\\\Option \ c \to \ Option \ 1\\\\Option \ d \to \ Option \ 2\\$

Explanation:

While time-consuming or prone to errors mechanical adjustments to both the referential, databases could be configured with four measures to engine violations. The restricted action causes the insert, update, and removes to only be denied. Set Null to NULL sets the invalid external key, whereas Set Default to a specific core consideration specified in SQL sets a default foreign key. Its Cascade operation spreads the main changes in external keys.

In which of the following situations must you stop for a school bus with flashing red lights?

None of the choices are correct.

on a highway that is divided into two separate roadways if you are on the SAME roadway as the school bus

you never have to stop for a school bus as long as you slow down and proceed with caution until you have completely passed it

on a highway that is divided into two separate roadways if you are on the OPPOSITE roadway as the school bus

Answers

The correct answer is:

on a highway that is divided into two separate roadways if you are on the OPPOSITE roadway as the school bus

What happens when a school bus is flashing red lights

When a school bus has its flashing red lights activated and the stop sign extended, it is indicating that students are either boarding or exiting the bus. In most jurisdictions, drivers are required to stop when they are on the opposite side of a divided highway from the school bus. This is to ensure the safety of the students crossing the road.

It is crucial to follow the specific laws and regulations of your local jurisdiction regarding school bus safety, as they may vary.

Learn more about school bus at

https://brainly.com/question/30615345

#SPJ1

You must give careful consideration before adding text to a placeholder because once text has been entered into a placeholder, the placeholder cannot be deleted.

True
False

Answers

False is your answer.

Lilyana has written the following function, but nothing happens when she runs her program. What has she forgotten to do?

def area(length, height):

area = length * height

return area

Answers

In this question, when Lilyana write a program to calculate the area, she forgot to call the method that's why it will not give any output. so, complete code with the output can be defined as follows:

Program Explanation:

Defining a method "area" that takes two variables "length, height" in the parameters.Inside the method, a variable "area" is declared that calculates the area by multiplies "length and width".After calculating the area a return keyword is used that returns its value.Outside the method, a print method is declared that calls the area method by accepting value into its parameters.

Program:

def area(length, height):#defining a method area that takes two parameters "length, height"

area = length * height#defining a variable area that calculates the area by multiplies length and width

return area#using return keyword that returns area value

print(area(6,8))#using a print method that calls area method by accepting the value

Output:

Please find the attached file.

Learn more:

brainly.com/question/8908120

Lilyana has written the following function, but nothing happens when she runs her program. What has she

Question 10 of 10
What information system would be most useful in determining what direction
to go in the next two years?
A. Decision support system
B. Transaction processing system
C. Executive information system
D. Management information system
SUBMIT

Answers

Answer: C. Executive information system

Explanation: The information system that would be most useful in determining what direction to go in the next two years is an Executive Information System (EIS). An EIS is designed to provide senior management with the information they need to make strategic decisions.

An Executive Information System (EIS) would be the most useful information system in determining what direction to go in the next two years. So, Option C is true.

Given that,

Most useful information about determining what direction to go in the next two years.

Since Executive Information System is specifically designed to provide senior executives with the necessary information and insights to support strategic decision-making.

It consolidates data from various sources, both internal and external, and presents it in a user-friendly format, such as dashboards or reports.

This enables executives to analyze trends, identify opportunities, and make informed decisions about the future direction of the organization.

EIS typically focuses on high-level, strategic information and is tailored to meet the specific needs of top-level executives.

So, the correct option is,

C. Executive information system

To learn more about Executive information systems visit:

https://brainly.com/question/16665679

#SPJ6

A user needs to communicate the same message with 20 people in a company. The message is lengthy with several images included in it. Which communication method would best fit this scenario? Describe the etiquette associated with communicating in this method.

Answers

Since the user needs to communicate the same message with 20 people in a company. The communication method would best fit this scenario is the use of a bulk email message.

What does "mail message" mean?

An email message is a text that is transmitted or received over a computer network and is often short as well as casual. Email communications are often only text messages, but they can also contain attachments (such spreadsheets and graphic files). Multiple people can receive an email message at once.

Therefore, The exchange of communications using electronic devices is known as electronic mail. At a time when "mail" solely referred to physical mail, email was therefore conceptualized as the electronic equivalent of or counterpart to mail.

Learn more about email message from

https://brainly.com/question/6180841
#SPJ1

A researcher investigated whether job applicants with popular (i.e. common) names are viewed more favorably than equally qualified applicants with less popular (i.e. uncommon) names. Participants in one group read resumes of job applicants with popular (i.e. common) names, while participants in the other group read the same resumes of the same job applicants but with unpopular (i.e. uncommon) names. The results showed that the differences in the evaluations of the applicants by the two groups were not significant at the .001 level

Answers

The study looked into whether job applicants with well-known names would do better than those with less well-known names who were similarly qualified. At a.001 level, the results revealed no significant differences in judgements.

What two conclusions may you draw from doing a hypothesis test?

There are two outcomes that can occur during a hypothesis test: either the null hypothesis is rejected or it is not. But keep in mind that hypothesis testing draws conclusions about a population using data from a sample.

What are the two sorts of research hypotheses?

A hypothesis is a general explanation for a set of facts that can be tested by targeted follow-up investigation. Alternative hypothesis and null hypothesis are the two main categories.

To know more about applicants visit:-

https://brainly.com/question/28206061

#SPJ9

Which of these communication avenues is not regulated by the Federal Communications Commission (FCC)?
1. Radio
2. Internet
3. Television
4. Satellite

Answers

The Federal Communications Commission regulates everything on here expect internet
ANSWER:
Internet

The most reliable way to store important files without having to worry about backups or media failure is ____________.

A) cloud storage
B) on a USB flash drive
C) on a hard disk drive
D) on an optical disc

Answers

The answer to this question is letter B

A. Cloud storage

The ideal approach to save data for a longer time is cloud storage. Data security and storage reliability are two advantages of cloud storage that can't be matched. In addition, end-to-end encryption ensures the safety of all transmitted data.

A serial schedule:

a. Can have a dirty read anomaly
b. Is always sorted sequentially in ascending order by transaction ID
c. Needs the current Xact to finish before another one starts
d. Is just theoretical and cannot be implemented in real life Reset Selection

Answers

Answer:

Explanation:

Is alwayd sorted sequentially in aceding order by transaction ID

Application software for an information system is usually a series of pre-programmed software modules supplied by a software publisher. t/f

Answers

True, An information system's application software often consists of a number of pre-written software modules that are provided by a software publisher.

What kind of software is intended to create additional software?

Software that is used to create other software is called programming software. The majority of these tools offer programmers a setting where they may create, test, and convert code into a form that can be executed on a computer.

What is software for applications?

Software for applications. the group of computer programs that assist a user with things including word processing, emailing, keeping tabs on finances, making presentations, editing images, enrolling in online courses, and playing games.

To know more about software visit:-

https://brainly.com/question/1022352

#SPJ4

Which key in is used in combination with another key to perform aspecific task

Answers

Answer:

control key

Explanation:

the control key modifies the function of the key with which it is pressed in combination

the expression y divided by 4 is equal to blank for y = 3.8.

Answers

The result of the calculation using equivalent expressions is that y = 3.8 - 3.8 = 0.

What is an Algebraic Expression?An algebraic expression is a mathematical expression made up of variables, coefficients, constants, and operations including addition, subtraction, multiplication, and division. In most cases, something is said to be equivalent if two of them are the same. Similar to this, analogous expressions in mathematics are those that, despite their differences in appearance, have the same meaning. The two expressions, however, produce the identical outcome when the values are inserted into them.

Example

Reading the input

Simplify y = 3.8.

Result:

y - 3.8 = 0.

To Learn more About equivalent expressions refer To:

https://brainly.com/question/24734894

#SPJ1

Which of the following are provided by most
professional organizations? Check all of the boxes
that apply.
uniforms
a code of conduct
legal representation
a network of professionals
skills validation

Answers

Answer:

B D E mark brain

Explanation:

i got a 100 on the whole lesson

Answer:

2. A code of conduct.

4. A network of professionals.

5. Skills validation.

Explanation: This is the correct answer on Edge 2021, just did the assignment. Hope this helps ^-^.

In order to average together values that match two different conditions in different ranges, an excel user should use the ____ function.

Answers

Answer: Excel Average functions

Explanation: it gets the work done.

Answer:

excel average

Explanation:

Your company has been assigned the 194.10.0.0/24 network for use at one of its sites. You need to calculate a subnet mask that will accommodate 60 hosts per subnet while maximizing the number of available subnets. What subnet mask will you use in CIDR notation?

Answers

To accommodate 60 hosts per subnet while maximizing the number of available subnets, we need to use a subnet mask that provides enough host bits and subnet bits.

How to calculate

To calculate the subnet mask, we determine the number of host bits required to accommodate 60 hosts: 2^6 = 64. Therefore, we need 6 host bits.

Subsequently, we determine the optimal quantity of subnet bits needed to increase the quantity of accessible subnets: the formula 2^n >= the amount of subnets is used. To account for multiple subnets, the value of n is set to 2, resulting in a total of 4 subnets.

Therefore, we need 2 subnet bits.

Combining the host bits (6) and subnet bits (2), we get a subnet mask of /28 in CIDR notation.