The National Database of Nursing Quality Indicators is an example of a database that collects nurse-sensitive indicators and patient outcomes at the same point in time. This allows analysts and decision-makers to place the results in context. In other words, did that patient fall occur when the staffing levels were low? Review the information on the NDNQI site and discuss how you would use these data to make decisions regarding administration and patient care.

1. How to generate database diagram for a database that stores information about the downloads that users make.

Each user must have an email address, first name, and last name.

Each user can have one or more downloads.

Each download must have a filename and download date/time.

Note: I want steps on how to generate this diagram using oracle SQL developer

Each product can be related to one or more downloads.

Each product must have a name.

Use MYSQL to create the set of database tables of the relational database model and complete the associated queries given.

Procedure: 1) Write all the SQL statements, necessary to create all tables and relationships, with Primary & Foreign keys.

2) Execute each statement in the correct order to create the relational database in MYSQL.

3)Insert some data into each table.

4) Use all your SQL create and Insert statements (from MS Word) to execute in the MYSQL WorkBench

5) Write in MS Word and execute in MYSQL WorkBench the statements necessary to; i. display all tables, ii. identify sales total for each item iii. identify delivery confirmation of sold items iv. identify marketing level for sold items

(Tables that have to be created)

• Sales details

• Marketing details

• Customer details

• Production details

• Delivery details

• Management details

B. Inventory management
The current policy is to order 100,000 units when the inventory level falls to 35,000 units. However, forecast demand to meet market requirements for next year is 625,000 units. The cost of placing and processing an order is R250, while the annual cost of holding a unit in stores is 5% of the unit purchase price. Both costs are expected to be constant during the next year. Shop n Pay sells a unit of the product for R15.00 at cost plus 50%. Orders are received two weeks after being placed with the supplier. You should assume a 350-day year and that demand is constant throughout the year.

C. Forecasting and other supply chain activities A recent report produced by Shop n Pay’s chief demand planner has revealed that the retailer’s reliance on simple exponential smoothing to forecast demand for its products is partly responsible for the significant bullwhip effect in the supply chain and the stock outs in the past few years. In this regard, the chief demand planner is recommending that exponential smoothing with trend adjustment (Holt’s Model) should be used to forecast demand for aggregate planning for the 2020 fiscal year.

Mr Msimanga has retrieved from the retailer’s database the following information on number of goods sold over a two–year period. Year Monthly sales (‘000 units)

Jan 2018 -650 /2019 -750

Feb 2018-700 /2019 -800

Mar 2018 -820/2019-900

Apr 2018 -850/2019-920

May 2018-700/2019- 680

Jun 2018-840/2019-950

Jul 2018-930/2019-1080

Aug 2018-630/2019-742

Sep 2018-860/2019-920

Oct 2018-600 /2019 -705

Nov 2018-1050/2019 -1100

Dec 2018 - 750 /2019- 820

2.3 REQUIRED: Use the information provided above under section C:

Forecasting and other supply chain activities to answer the following questions:

2.3.1 “A recent report produced by Shop n Pay’s chief demand planner has revealed that the retailer’s reliance on simple exponential smoothing to forecast demand for its products is partly responsible of the significant pile-up of goods in the company’s main distribution centre.”

2.3.2
Calculate the Exponential smoothing with trend component forecast (FIT) for second to the twenty-fifth month using an initial trend forecast (?1) of 10 000, an initial exponential smoothing forecast (?1) of 640 000 units, ?=0.20, and ?=0.30.
2.3.3
Plot the actual demand, the simple exponential smoothing (SES) forecast, and trend-adjusted exponential smoothing (FIT) forecast on the same graph. Briefly comment on the observed difference(s) between the plots of the two forecasts.

Please provide your thoughts about the efficient market hypothesis (EMH) and how the 2007-2009 recession are related. Please add citations and references.

Locate 2-3 articles related to Generational differences and how the differences create conflict, summarize and discuss.

Be sure to include reference citations for support

write importance of geology to civil engineer, maps,

same should be reflected in the references

What dimensions of Corporate Social Responsibility do you believe are the most important and why? Please use citations and references to support your position.

In about 300 (4 paragraphs) words explain the Communication Theories and how they impact communication with peers, family and in the work place – use in text citations