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:

For questions 1 - 4, please consider the following [fictitious] scenario.

Lehigh Valley Health Network, a not-for-profit health system with 8 hospitals, is considering switching to a project scoring methodology to evaluate project potential for capital allocation purposes. The CEO of the health system, Dr. Brian Nester, believes that such a methodology would help the leadership team get a more complete picture of the implications of different projects, beyond purely financial measures. The goal for any decision support methodology such as this one is to provide a useful tool for decision makers that leads to good decisions consistently. Dr. Nester has hired an analyst (you) to help them out with developing this methodology.

Q1 [10 points].

Propose a set of criteria that the LVHN team could use to evaluate projects for capital allocation. Organize your criteria in appropriate categories or buckets (e.g. you may consider a subset of operational impact criteria, a subset of financial criteria, community impact etc.). Finally, for each criterion in each bucket, provide a 1-3 sentence rationale behind including it in your selection of criteria to be used for evaluation.

Some (hopefully helpful) hints:

• To identify relevant criteria, you may wish to consider the mission and values of the organization, the different stakeholders that may be part of the LVHN community, the various aspects of the organization that may be impacted etc.
• Too many criteria creates a situation where any meaningful comparison becomes difficult; on the other hand, too few criteria may not provide sufficient “resolution” to be able to differentiate between alternative projects. Unfortunately, there is no magic number - hence the need to provide a rationale and think carefully about what criteria should be included. In general, you want to aim for the fewest that you believe capture all relevant dimensions of analysis.
• Finally, for a given criterion, consider the “ability to measure” how well a given project can satisfy it - in the end, a criterion for which we cannot determine how well a project satisfies it is not that useful. Note that it is possible for a specific criterion not to be itself measurable, e.g. “the project increases the level of confidence that the community has in LVHN services” - how would someone measure that? It is, however, possible to see some measurable effects of this, for instance an increase in “second opinion requests” addressed to LVHN physicians (which we could assume to mean that people trust LVHN more and therefore come to LVHN for second opinions).

[Bonus] 0.5 points for each specific metric that you can use to evaluate how a criterion is impacted by a given project - e.g. “increase in # second opinion requests can be used to measure the improvement in community trust in LVHN physicians”.

Williamson Industries has $4 billion in sales and $1 billion in fixed assets. Currently, the company's fixed assets are operating at 95% of capacity.

Question 1
With reference to the extract, explain workforce diversity and discuss four (4) reasons why it
is necessary to increase workforce diversity in South Africa.

Question 2

According to the extract, it is only when the leadership embraces diversity and makes it an
organisational priority, will its true benefits be seen. Based on this, critically discus five (5)
organisational approaches to the management of diversity.

CH 12 Homework

Question 4 of 5

- / 1

View Policies

Current Attempt in Progress

Blue Spruce Corp.’s comparative balance sheets are presented below:

Additional information:

Prepare a statement of cash flows for 2019 using the indirect method.

Compute free cash flow

11. Don, Ellen and Frances are partners that share income in the 6:4:1 ratio. On December 31, Frances withdraws from the partnership when the equities of the partners are Don, $6,000; Ellen, $3,600; and Frances, $2,400. Prepare the journal entry when Frances withdraws from the partnership and is paid using partnership cash of $1,400. 12. GHI Partnership was begun with investments by the partners as follows: G, $131,250; H, $165,000 and I, $153,750. The partners agreed to liquidate the partnership to share losses equally. On May 31, after all assets were converted to cash and creditors were paid, only $30,000 partnership cash remained. Compute the capital account balance of each partner after the liquidation of assets and the payment of creditors. Record the entries to allocate and loss on realization and the distribution of cash of $30,000.

WEEK 3 DISCUSSION# 4

ANSWER THE FOLLOWING :

1: Fully explain how to use one of the threat modeling tools

2: What are the benefits or issues with Microsoft’s Threat Modeling process and tool?

1. A charter flight charges a fare of $200per person plus an additional $4 per person for each unsold seat on a plane that holds a maximum of 100 passengers. Let x represent the number of unsold seats.

a)Express the number of passengers on the flight as a function of x. Call this functionQ(x).

b)Express the price per ticket on the flight as a function of x. Call this functionP(x)

c)Express the total revenue received for the flight as a function of x. Call this functionR(x)

d)Find the number of unsold seats that will produce the maximum revenue as well as what the maximum revenue is (rounded to the nearest cent). Explain how you found your answer using complete sentence

Cuneo Company’s income statements for the last 3 years are as follows:

Labels and Amount Descriptions

Refer to the list below for the exact wording of an account title within your income statement.

Common-Size Income Statement

1. Prepare a common-size income statement for Year 2 by expressing each line item for Year 2 as a percentage of that same line item from Year 1. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.)

2. Prepare a common-size income statement for Year 3 by expressing each line item for Year 3 as a percentage of that same line item from Year 1. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.)