For Problems 1–4, using the STORES Database, formulate SQL queries, Hand in a listing of each query and its output.

1. (10 Points) For each customer, list each stock item ordered, the manufacturer, the quantity ordered, and the total price paid. Include the following columns in the order given below:

From Customer Table:              Company

From Stock Table:                      Description

From the Manufact Table:        Manu_Name

From the Items Table:                                Quantity, Total Price

Order the output by Company and Description.

2. (10 Points) List all orders with a shipping date between December 25, 1999 and January 5, 2000. List the Order Number, Order Date, Customer company name, and Shipping Date. Order by Customer Company Name and Order Number.

3. (10 Points) Count the number of customers who do not have any orders placed.

4. (10 Points) List all customers who are ordering equipment whose description begins with ‘tennis’ or ‘volleyball’. List the Customer number, Stock number, and Description. Do not repeat any rows.

5. (15 Points) Use the following SQL CREATE commands to CREATE the following tables in your

User ID:

                                CREATE TABLE Professor

                                (Prof_ID                NUMBER(3) Constraint pk_Professor Primary Key,

                                Prof_Lname         VARCHAR2(15)                 NOT NULL,

                                Prof_Hiredate      DATE,

                                Prof_Sal                NUMBER(8,2),

                                Prof_Dept             CHAR(6)

                                );

                                CREATE TABLE Student

                                (Stu_ID                  NUMBER(4) Constraint pk_Student Primary Key,

                                Stu_Lname           VARCHAR2(15)                 NOT NULL,

                                Stu_Major            CHAR(6),

Stu_CredHrs         NUMBER(4),

                                Stu_GradePts       NUMBER(5),

                                Prof_ID                 NUMBER(3),

                                CONSTRAINT fk_Student_Prof_ID FOREIGN KEY(Prof_ID)

                                                REFERENCES Professor

                                );

Hand in: Print out of the Create commands, the system response and a DESCRIBE of the tables.

6. (15 Points) Insert the following data into the tables created above using SQL INSERT commands.

Professor Table:

Student Table:

Hi, can you answer this question in more detail?

Subject: Quality Management and Practices

8.

Research on the current state of Toyota's Company quality management covers the following topics, demonstrate your theoretical understanding and skills in evaluating existing operational management issues, and use a quality management framework for analysis.

• Total Quality Management…

( Words: 900 - Need to be original, Don't direct copy )

Feminism promotes equality between men and women, and argues that we must address historical power imbalances in order to bring about such equality. Intersectional feminism builds on this idea, but recognizes that gender is not the only source of privilege or oppression: race, class, nationality, sexual orientation, disability status, etc. are other factors. We have complex identities, and a person can be privileged in some ways, but oppressed in others. Thus, intersectional feminism brings greater nuance to the quest for equality.

What are some possible benefits and drawbacks of using the concept of “intersectionality” to analyze literature? How might this concept help us better understand the themes or characters of a work?

2. Describe three ways in which the visual system compensates for aspects of the visual stimulus to give us perceptions of a stable, real physical world.

3. What does it mean to assume that the mind is modular? Make sure to clearly distinguish this view from the view that processing structures in the brain are domain general. What evidence supports the modular view and what evidence undermines it?

4. What is difference between bottom-up and top-down processing? Describe in detail an example of each from the theories of visual pattern recognition.

5. What is the difference between an early selection model of attention and a late selection model of attention? Describe an example of each kind of model, including discussing what makes it a model of that type.

A 2.49-kg cart on a long, level, low-friction track is heading for a small electric fan at 0.25 m/s . The fan, which was initially off, is turned on. As the fan speeds up, the magnitude of the force it exerts on the cart is given by at2, where a = 0.0200 N/s2.

Part A

What is the speed of the cart 3.5 s after the fan is turned on?

Part B

After how many seconds is the cart's velocity zero?

Develop a simple point-to-point Message communication system(Java Message Service) using ActiveMQ. Provide the necessary code.

Using C++,

Write a program that will use pointer syntax to access variables, dynamically allocate memories, and pass pointers to functions.

1.            The program should ask the user to enter a size to the array.

2.            The program should dynamically allocate an array with the size.

3.            The program should then ask user to input values to the array

4.            The program should then find the maximum, display all elements forward and reversed using two different ways of pointer access

5.            The program must use functions with pointers as parameters.

6.            The manipulation/access of the array must be done through pointer syntax.

7.            Your main function should only declare the variables and call the functions.

Variable:

You’ll need the following pointer to be declared in your main function.

float * ptData;

Data Validation:

1.            The size of the array cannot be less or equal to 1 (E.g. 2, 5, 100 is fine, but 1 or 0 is no acceptable).

2.            Check if pointer has successfully allocated the array.

Functions:

               You should have separate functions to handle user input, maximum, and display the array (all the values needs to be returned to the function call, you need to have pointer as the input parameter). Main function should only call other functions.

Sample Output:

4. Forty-three milliliters of 0.130 M nitric acid is added to 30.0 mL of 0.095 M calcium hydroxide. Calculate the pH of the initial nitric acid solution and then calculate the pH of the combined solutions. Assume the solution volumes are additive. Hint: determine whether excess H+ or OH- remain in solution after neutralization, then calculate the pH.

Show all steps please to help me understand, thank you!

For each of the situations described below, select the type of analytics that would address the specific organizational need and justify your selection.

b. A large retail chain wants to understand what factors contributed to the overall sales decline it experienced in a specific month in the past.

c. To support staffing analysis for a holiday season, a clothing store wants to improve its understanding of the number of customers that are likely to visit each of its stores during the November 15–January 15 time frame.

d. A gaming company wants to provide all of its employees an up-to-date graphical representation of the number of downloads of its game products and in-app revenue associated with them.

You are the owner of Smalltown Computer, a local computer repair store that also assembles custom computers to order. The company has been very successful and is growing exponentially. However, the company is having difficulty preparing for future growth. The only information system the company has is an accounting system.

1. Evaluate Smalltown Computer using the Competitive Forces model.
2. Which strategy should the company adopt in order to retain its competitive edge and why?
3. Which strategic business objective can Smalltown Computer achieve? Justify.
4. Based on the strategy and strategic business objective you selected above, which two systems (not general applications like Enterprise Systems, CRM, SCM or Knowledge Management. Be specific in your answer e.g. “inventory management system”) would you recommend for which functional area(s)? Justify your choice using the Value Chain model.

1.    List and explain at least two forces of the external environment (General or Industry) that are causing all companies --not just Volkswagen-- to become more sensitive to environmental issues.

2.    Before the scandal, what was Volkswagen's apparent position on the environment, and what did the company do to ensure that stakeholders (i.e., customers, employees, society) knew this position?

-List at least two ways in which VW communicated this stance to stakeholders

3.    Based on the industry forces, describe the nature of competition in the global automobile industry and explain the reasons for this rivalry.

To what extent do you think competition led to the Volkswagen scandal?

4.    Describe two (2) of Volkswagen's responses to the allegations.

A load ZL = 80− j100 is located at z = 0 on a lossless 50- line.
The operating frequency is 200 MHz and the wavelength on the line is 2 m.
(a) If the line is 0.8 m in length, use the Smith chart to find the input impedance.
(b) What is s? (c) What is the distance from the load to the nearest voltage
maximum? (d) What is the distance from the input to the nearest point at which
the remainder of the line could be replaced by a pure resistance?

Blue Skies Equipment Company uses the aging approach to estimate bad debt expense at the end of each accounting year. Credit sales occur frequently on terms n/60. The balance of each account receivable is aged on the basis of three time periods as follows: (1) not yet due, (2) up to one year past due, and (3) more than one year past due. Experience has shown that for each age group, the average loss rate on the amount of the receivable at year-end due to uncollectibility is (a) 9 percent, (b) 12 percent, and (c) 35 percent, respectively.

At December 31, 2019 (end of the current accounting year), the Accounts Receivable balance was $49,900 and the Allowance for Doubtful Accounts balance was $1,000 (credit). In determining which accounts have been paid, the company applies collections to the oldest sales first. To simplify, only five customer accounts are used; the details of each on December 31, 2019, follow:

Required:

1. Compute the estimated uncollectiable amount for each age category and in total

Not yet Due______

Up to one year past due______

More than one year past due____

Total accounts recieveable___

2) Journal Entry

3)Partial Income Statement & Partial Balance sheet

g. Crazing and peeling are defects associated with glazing process; explain how they are different, and how they can be prevented?
h. Identify at least THREE processes that are line of sight processes.
i. List at least one limitation of PVD process.
j. Identify at least one failure mechanism associated with CVD coatings.
k. Gas turbine blades are to be refurbished; identify the process(es) and major steps involved in this process.
l. Identify at least TWO limitations of flame spraying.
m. What is a comparative advantage of using plasma arc thermal spraying process?

Discuss if ethically managed organisations are more profitable than other. Also, explain can an installation of ethics officer and adoption of “compliance and ethics program” will improve the organisational efficiency and effectiveness.