Entries by Student

write my assignment 9277

“Alaska Coffee Company (ACC) confronts operational issues and a major competitor’s entry into its home market. The company’s key leaders are in need of strategic management advice to handle the increased complexities of a growing enterprise. As a member of the company’s strategy team, you have been tasked with analyzing some of ACC’s strategic challenges and preparing a report for the company’s top management and board of directors.Your report should include the following information. 1. Leadership – Identify leadership issues requiring Powell’s attention during the strategic management process.2. External Environmental Analysis – Identify at least two each general, industry and competitor forces with immediate strategic implications for ACC. For each one specifically, list: what the force is, why it is significant and what ACC may do to react to the particular force.3. Industry Analysis – Use Porter’s Five Forces model to analyze the characteristics of ACC’s industry environment.

 

"Not answered?"


Get the Answer

November 24, 2021by

write my assignment 8028

17. Consider a 1000 meter high column of air sitting next to an identically-shaped 1000 m high column of liquid water.

a. Which container will have the highest fluid pressure at the bottom of the column of fluid, or will they be the same? Explain your answer. (NOTE: The fluid pressure is water pressure in the water column and air pressure in the air column).

b. Exactly halfway up the column of air (500 m above the bottom and 500 m below the top), would you expect the air pressure to be exactly half of what it is at the 7 bottom, more than half as much as it is at the bottom, or less than half as much as it is at the bottom? Explain your answer. Include important differences between air and water.

17. Consider a 1000 meter high column of air sitting next to an identically-shaped 1000 m high column of liquid water.a. Which container will have the highest fluid pressure at the bottom of the…

 

"Not answered?"


Get the Answer

November 24, 2021by

write my assignment 12790

Multiple Regression.   This data is based on a random sample of housing sales in Newark, DE from 2005 to 2008. The total sample size is 131 houses. The dependent variable is PRICE in $1,000s (the actual sale price is divided by 1,000). We will look at four independent variables.

  • AREA                  The total square footage of the house
  • LOTSIZE            The size of the lot in acres
  • BEDROOMS   The number of bedrooms in the house
  • BATHDUM       A dummy variable for the number of full bathrooms where 1 = 2 or more bathrooms, 0 = 1 bathroom

Summary of FitRSquare1RSquare Adj0.6934Root Mean Square Error34.9853Mean of Response237.2661Observations (or SumWgts)131Analysis of VarianceSourceDFSum of Squares Mean SquareF RatioModel2364730.6534Error561223.97Prob > F<.0001C. Total130518950.89Parameter EstimatesTermEstimateStd Errort RatioProb>|t|Intercept56.766919.05572.9790.0035AREA0.04960.00935.3322<.0001LOTSIZE117.04716.93657<.0001BEDROOMS18.1655.97133.04210.0029BATHDUM35.47147.00065.0669<.0001What is R-square for the model (1)? I just want the numerical answer as a proportion. Use 4 decimal places and use theproper rules of rounding.

 

"Not answered?"


Get the Answer

November 24, 2021by

write my assignment 27295

The assignment reads for DBM 449 Advanced topics in database

“STEP 5: Using the Materialized View

1. First, CALL REFRESH_MV_SALESBYMONTH. This will make sure that the view is created, and currently up-to-date.

2. Run the SQL statement: SELECT * FROM MV_SALESBYMONTH. The output columns from your view should look similar to the following (use aliases to format the column headings) and you should have 18 rows in the result set.

YEAR     MONTH PRODUCT CO UNITS SOLD SALES TOTAL

Now we are going to add some data and update the view. Remember, we must manually run the stored procedure to update the view, as it will not (yet!) automatically itself.

1. To begin with, insert the following data into the SALES table—(207, 110016, ‘SM-18277’,1,8.95).

2. CALL the stored procedure to refresh the view. 

3. Query the view once again.

You should now see that the row for units sold in month 10 for SM-18277 has increased from 3 to 4 and total sales amount has gone from 26.85 to 35.80.

4. Delete the row you just added to the SALES table, and call the stored procedure to refresh the view, proving that things are up-to-date.

5. Create a Trigger on the SALES table so that any insert automatically fires off the stored procedure to update the view.

6. Test your trigger, by again inserting the following data into the SALES table—(207, 110016, ‘SM-18277’,1,8.95).

7. Query the view once again.

You should now see that the row for units sold in month 10 for SM-18277 has increased from 3 to 4 and total sales amount has gone from 26.85 to 35.80. “

REFRESH_MV_SALESBYMONTH is a stored procedure written as follows

DELIMITER $$

CREATE PROCEDURE REFRESH_MV_SALESBYMONTH()

BEGIN

DROP TABLE IF EXISTS `MV_SALESBYMONTH`;

CREATE TABLE `MV_SALESBYMONTH`(

SELECT TIME_YEAR AS ‘YEAR’, TIME_MONTH AS ‘MONTH’, PROD_CODE AS ‘PRODUCT’,

SUM(SALE_UNITS) AS ‘UNITS SOLD’, SUM(SALE_UNITS*SALE_PRICE) AS ‘SALES TOTAL’

FROM TIME T, SALES S

WHERE S.TIME_ID = T.TIME_ID

GROUP BY TIME_YEAR, TIME_MONTH, PROD_CODE);

END $$

DELIMITER ;

I am struggling with step 5 second part numbers 5 and 6

I created the trigger with this code:

delimiter //

CREATE TRIGGER TRIG_SALES AFTER INSERT ON SALES

FOR EACH ROW

BEGIN

CALL dbm449lab6.REFRESH_MV_SALESBYMONTH();

END//

delimiter ;

but when i run the insert statement for part 6 i get an error that reads: SQL Error (1422): Explicit or implicit commit is not allowed in stored function or trigger.

I don’t know what i am doing wrong or how to fix it. Can you help?

 

"Not answered?"


Get the Answer

November 24, 2021by