USING SQL

Create a table named Zones with the attributes and assumptions indicated below.

• Attributes: the zone ID, the lowest and the highest accepted temperature.

Assumptions: the ID will be the primary key and have one or two digits, the temperatures (in Fahrenheit) will be at most two digits and a possible minus sign, none of the temperatures can be NULL.

Populate table Zones so that it has the following rows:

3. Deliveries

The same flower vendor wants to use a code to explain the type of delivery for each flower. Create a table named Deliveries with the attributes and assumptions indicated below.

• Attributes: the delivery ID, the category or type of delivery, and the size of the delivery.

• Assumptions: the ID will be the primary key and have one one digit, the category will be at most five characters (pot, plant, hedge, shrub, tree), and the delivery size will be up to five digits with three decimal spaces (possibly NULL).

Populate table Deliveries so that it has the following rows:

3. FlowersInfo

Create a table named FlowersInfo with the attributes and assumptions indicated below. Choose the most appropriate data types.

Attributes: an ID with three characters, common name, Latin name, the coolest and hottest zones where it can be grown, the delivery category, and the sun needs.

Assumptions: The ID will be the primary key, the attribute common name may have up to thirty characters, and the Latin name up to thirty-five characters. The attributes coolest zone, hottest zone, and delivery category will match the IDs from other tables, and the sun needs will be up to five characters, S for Sun, SH for Shade, P for Partial sun and any combination (StoP, StoSH, etc.). Your table definition should implement referential integrity whenever possible.
Populate table FlowersInfo so that it has the following rows:

4. Queries

Write SQL statements to answer the following queries. Write a comment header right before each SQL statement with the letter of the query answered by the statement.

a) the total number of zones.

b) the number of flowers per cool zone.

c) common names of the plants that have delivery sizes less than 5.

d) common names of the plants that require full sun (i.e., sun needs contains ‘S’).

e) all delivery category names order alphabetically (without repetition).

f) the exact output (note that it is order by Name):

case study read the following case study:

best hospital is a 325-bed suburban community hospital ... Your question has been posted. We'll notify you when a Chegg Expert has answered. Post another question. Next time just snap a photo of your problem. No typing, no scanning, no explanation required. Get Chegg Study App Question: Case study read the following case study: best hospital is a 325-bed suburban community hospital ... Edit question Case study read the following case study: best hospital is a 325-bed suburban community hospital ... Question: Case Study Read the following case study: Best Hospital is a 325-bed suburban community hospital ... Edit question Case Study Read the following case study: Best Hospital is a 325-bed suburban community hospital that has just merged with a local major academic medical center, the University of Excellence Medical Center (UEMC). There are 15 hospitals in the UEMC system, ranging from small rural hospitals with 50 or fewer beds to large multiple-specialty tertiary referral hospitals. Two hospitals in the system have achieved magnet status and several hospitals are working to achieve this status. Within the UEMC system, a high value is placed on collaboration with the schools of the health professions at the University of Excellence (UE). Best Hospital has a long history of association with local universities, functioning mainly as a site for student clinical experiences. For example, undergraduate students enrolled at the UE College of Health Professions often complete a portion of their clinical work at the hospital. Each year the hospital hires a number of graduates from this program. Several nurses in first-level management positions at the hospital are enrolled in the master’s program. The vice-president for clinical practice at Best Hospital is a PhD-prepared nurse who has been appointed to the faculty at the UE School of Nursing. Your current position is director of staff development at Best Hospital. You are responsible for the educational programming of all clinical staff. Over the past 2 years, Best Hospital has been fully involved in meeting Meaningful Use criteria. As director of staff development, you have played the major leadership role in developing and implementing all related educational programs. The health professional schools at UE are working together to revise their curricula to integrate informatics throughout. The goal is to develop an interprofessional approach that incorporates informatics across and throughout the different educational programs within these schools. The schools have requested a meeting with clinical leaders from the hospital to gain a practical perspective on what information should be included in the curricula. The vice-president for clinical practice has included you on the list of leaders to attend the meeting. She asked that each person attending the meeting prepare a short presentation on how they engage their staff in the continuous education process with respect to ever-changing healthcare technology.

Review the case study.

1. Give an overview process map on how staff training is linked to any update in healthcare technology for Best Hospital staff

2. List examples of computerized teaching tools used within staff training, including: List of learning tools typically used within staff training

3. How you determine which tools to use (rationale) 4.How such tools are used within the training process

Support of continuous learning by staff

1. Existing support mechanisms and processes

2. How continuous learning is linked to professional development

3. Examples of how learning is offered for diverse learning styles of staff

1. What is an industry that has only one significant supplier? What is the nature of the product? How easy would it be to start a similar firm or stop offering the product/service? How easy is it to attain information about the industry or product or service?

2. Are there any products that are sold in a market in which the seller is able to charge different prices to different consumers? How are the sellers able to do this?

3. Suppose you own one of two gas stations in a town of 5,000. The two gas stations are right across the street from each other. How would you react to changes in your competitors prices? What would cause you to increase or decrease prices? How would you get more business? Would your pricing strategy change if you were friends with the owner of the other station?

4. Can you think of an industry that is dominated by only 2-3 firms? What is the nature of the product? Would it be easy to begin offering the product or service? Do you feel that the prices of the products they are offering are fair?

The mean credit card debt among households in one state is $8400. A hypothesis test is to be performed to decide whether the mean credit card debt for households in the formerly affluent town of Rich-No-More differs from the mean credit card debt for the state. The hypotheses are H0: ? = $8400 Ha: ? ? $8400 where ? is the mean credit card debt for all households in Rich-No-More. Explain the meaning of a correct decision.

A correct decision would occur if, in fact, ? = $8400, and the results of the sampling do not lead to rejection of that fact; or if, in fact, ? ? $8400 and the results of the sampling do not lead to rejection of the null hypothesis that ? = $8400.

A correct decision would occur if, in fact, ? = $8400, and the results of the sampling do not lead to rejection of that fact; or if, in fact, ? ? $8400 and the results of the sampling lead to that conclusion.

A correct decision would occur if, in fact, ? = $8400, but the results of the sampling lead to the conclusion that ? ? $8400; or if, in fact, ? ? $8400 and the results of the sampling lead to that conclusion.

A correct decision would occur if, in fact, ? ? $8400, and the results of the sampling do not lead to rejection of the null hypothesis that ? = $8400

Using Supply and Demand to Analyze Markets — End of Chapter Problem

Every autumn brings an increase in the demand for pumpkin spice lattes (PSL). This fall, the demand for PSLs in a mid‑sized midwestern town is given by ??=10−0.5?, where P is the price of a PSL in dollars and Q is thousands of PSLs per day. The corresponding supply is given by ??=−5+2?. The equilibrium price of a PSL is P^E = $6; the equilibrium quantity is ??=7. Eager to capitalize on the addictive nature of the PSL, the City Council decides to impose a $1 tax on pumpkin spice lattes. “We can use the proceeds to fund an espresso machine for City Hall!” they rave.

a. At equilibrium price and quantity,

what is the price elasticity of demand?

what is the price elasticity of supply?

b. after the City Council decides to impose a $1 tax on pumpkin spice lattes,

what is the share of the tax borne by consumers?

what is the share of the tax borne by sellers?

c. After the tax is imposed,

What is the expected price buyers will have to pay? ____ dollars

What is the expected price sellers will receive? _____dollars

Questions 8-10. In one study, the correlation between the educational level of husbands and wives in a certain town was about 0.50; both averaged 12 years of schooling completed, each with a SD of 3 years.

Question 8 Predict the educational level of a woman whose husband has completed 18 years of schooling.

Question 8 (Choose the best answer)

A15

B. 16

C. 17

D. 18

E. 19

Question 9 Predict the education level of a man whose wife has completed 15 years of schooling.

Question 9 Choose the right answer

A13.5

B. 12.5

C. 11.5

D. 10.5

E. None of the above

Question 10 Apparently, well educated men marry women who are less well educated than themselves. But the women marry men with even less education. How is this possible?

Select the best answer among the choices

A Regression Effect

B. Law of Averages

C. Different Subgroups

D. Randomized Control Groups

E. Chance error

Pamplona, Spain is the home of the festival of San Fermin – The Running of the Bulls. The town is in festival mode for a week and a half every year at the beginning of July. There is a running joke in the city, that Pamplona has a baby boom every April – 9 months after San Fermin. To test this claim, a resident takes a random sample of 200 birthdays from native residents and finds the following observed counts:

At the 0.05 level of significance, can it be concluded that births in Pamplona are not equally distributed throughout the 12 months of the year?

Hypotheses:

H0: Births in Pamplona _____ equally distributed throughout the year.

H1: Births in Pamplona _____ equally distributed throughout the year.

Enter the test statistic - round to 4 decimal places.

Enter the p-value - round to 4 decimal places.

Can it be concluded that births in Pamplona are not equally distributed throughout the 12 months of the year?

As part of his effort in promoting innovation and healthy relationship among all the

employees working in different locations (branches), Andrus started an annual activity

where groups of employees (based on location) compete to pitch their most extreme ideas

to one another. Each group would present their ideas, then the branches vote one by one.

(They are not allowed to vote for their own branch) Each branch awards 8 votes to their

favorite, 4 to the second, 2 to the third and 1 to the fourth. Clearly, tactical voting is

important, so the order of voting is changed every year. This year, the branches vote in

order from most northerly to most southerly. The results before the last two branches have

voted are shown below (in voting order). Who still stands a chance of winning? Walk me

through your entire thought process!

You are now 80 years old; you have lost your spouse, your children are grown and now live out of town. Your vision has failed so you no longer have the ability to drive. Osteoarthritis has made it difficult for you to walk and raise your arms above your head. This has forced you to use a walker. You no longer have the ability to prepare your own food or to bathe yourself. Your hearing has also failed you and so the television is no longer a form of entertainment. Your children have had to put you into an assisted living facility .You must live in a 8 x 24 square foot room. Because of the cost, you must have a roommate.

1. Describe three possessions you will keep to take with you to the facility. (No pets).

2. List 5 cherished freedoms you will miss the most.

3. In a paragraph describe how it makes you feel.

4. Write a second paragraph using the phrase "Growing old is not for the faint of heart."