The following tables form part of a database held in a relational DBMS:

Hotel (hotelNo, hotelName, hotelAddress, country)

Room (roomNo, hotelNo, type, price)

Guest (guestNo, guestName, guestAddress, country)

Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

Write the SQL statements for the following questions:

1. List the rooms that are currently unoccupied at the Grosvenor Hotel, for:

(a) Use 2019-10-01 as today's date. Include all 'Grosvenor' hotels. List in hotelNo, roomNo order. Use NOT IN to perform the difference operation

(b) Use 2019-10-01 as today's date. Include all 'Grosvenor' hotels. List in hotelNo, roomNo order. Use NOT EXISTS to perform the difference operation.

(c) Use 2019-10-01 as today's date. Include all 'Grosvenor' hotels. List in hotelNo, roomNo order. Use LEFT JOIN to perform the difference operation.

(d) Use 2019-10-01 as today's date. Include all 'Grosvenor' hotels. List in hotelNo, roomNo order. Use MINUS to perform the difference operation.

James is a college senior who is majoring in Risk Management and Insurance. He owns a high-mileage 1998 Honda Civic that has a market value of $2,800. The current replacement value of his clothes, television sets, stereo set, cell phone, and other property in a rented apartment totals $9,000. He has a waterbed in his rented apartment that has leaked in the past. An avid runner, James runs 5 miles daily in a nearby public park that has the reputation of being very dangerous because of drug dealers, numerous assaults and muggings, and drive-by shootings. For each of the following risks or loss exposures, identify an appropriate risk management technique that could have been used to deal with the exposure. Explain your answer. (3 questions)

1. Liability lawsuit against James arising out of negligent operation of his car

2. Waterbed leak that causes property damage to the apartment

3. Physical assault on James by gang members who are dealing drugs in the park where he runs

At year-end December 31, Chan Company estimates its bad debts as 0.20% of its annual credit sales of $603,000. Chan records its Bad Debts Expense for that estimate. On the following February 1, Chan decides that the $302 account of P. Park is uncollectible and writes it off as a bad debt. On June 5, Park unexpectedly pays the amount previously written off.

Prepare Chan's journal entries to record the transactions of December 31, February 1, and June 5.

• Record the estimated bad debts expense.

Note: Enter debits before credits.

• Wrote off P. Park's account as uncollectible.

Note: Enter debits before credits.

• Reinstated Park's previously written off account.

Note: Enter debits before credits.

• Record the cash received on account.

Note: Enter debits before credits.

In 1997, Scottish researchers captured newspaper headlines when they announced the birth of Dolly, a lamb cloned from an adult sheep by nuclear transplantation. These researchers cultured mammary (nuclear-donor) cells in a nutrient-poor medium and then fused these cells with enucleated sheep eggs. The resulting diploid cells divided to form early embryos, which were implanted into surrogate mothers. Out of several hundred implanted embryos, one successfully completed normal development, and Dolly was born. Later analyses showed that Dolly’s chromosomal DNA was identical to that of the nucleus donor. Numerous other animals have been cloned thus far. In fact, the science fiction plot of Jurassic Park, revolves around a theme park showcasing cloned dinosaurs. These dinosaurs were cloned from DNA found in mosquitoes that had sucked dinosaur blood and had been trapped and preserved in amber.

In this discussion, explain (in 250-300 words) why you think it is possible to recreate dinosaurs by this technique. (PLEASE TYPE & INCLUDE 1 - 2 SOURCES, NO DIAGRAMS)

Case Study 8.1

In February 2017 the price of a daily pass to drive on a Volusia County beach was $10, and at that price 26,467 daily passes were sold. In February 2018 the price of a daily pass rose to $20, and at that price the number of daily passes sold dropped to 17,994.

1. What is the elasticity of demand for the daily pass? Is the demand elastic or inelastic? Explain the meaning of your answer in the context of this problem. Is revenue increasing or decreasing?
2. The County Council may consider raising the price of a daily pass to $30 next year. Based on elasticity of demand, should the Council consider another increase? Please justify your answer.

Case Study 8.2

Demand for tickets to a theme park, based on average daily attendance, is given by           Dp=-7.7p2+495.8p+20,000, where p is the daily admission price. The current admission price is $75, but the park is considering raising the price to $80.

3. At $75, what is the elasticity of demand for the tickets? Is the demand elastic or inelastic? Based on elasticity of demand, should the price be increased?
4. What should the ticket price be for maximum revenue?

A study was conducted to see whether two types of cars, A and B, took the same time to parallel park. Seven drivers were randomly obtained and the time required for each of them to parallel park (in seconds) each of the 2 cars was measured. The results are listed below in order of driver (e.g. the first listing for A and B are driver 1; the second listing driver 2; etc.) Car A: 19, 21.8, 16.8, 24.2, 22, 34.7, 23.8 Car B: 17.8, 20.2, 16.2, 41.4, 21.4, 28.4, 22.7

A. Explain why this is a paired test and not a two sample test.

B. Test whether the there is a difference in mean parallel parking time of the two cars at a 0.05 level of significance. Include the hypotheses, the test statistic, the p-value, test decision and conclusion in the context of the problem.

C. Do you believe the test results are valid? Explain.

D. What test decision error could you have made and provide an explanation of this error in context of the problem. E. Include a copy of your R-code and test output.

1. At a particular amusement park, most of the live characters have height requirements of a minimum of 57 in. and a maximum of 63 in. A survey found that​ women's heights are normally distributed with a mean of 62.4 in. and a standard deviation of 3.6 in. The survey also found that​ men's heights are normally distributed with a mean of 68.3 in. and a standard deviation of 3.6 in.
   
   Part 1:
   Find the percentage of men meeting the height requirement.
   
   The percentage of men who meet the height requirement is ____?____.
   ​(Round answer to nearest hundredth of a percent - i.e. 23.34%)
   
   What does the result suggest about the genders of the people who are employed as characters at the amusement​ park?
   Since most men___?___ the height​ requirement, it likely that most of the characters are ___?___ .
   (Use "meet" or "do not meet" for the first blank and "men" or "women" for the second blank.)
   
   Part 2: I was able to solve part 2 on my own.
   If the height requirements are changed to exclude only the tallest​ 50% of men and the shortest​ 5% of​ men, what are the new height​ requirements?
   The new height requirements are a minimum of 62.4 in. and a maximum of 68.3 in.
   ​(Round to one decimal place as​ needed.)

1. Draw the decision tables for all the problems below
2. For the decision tables above, reduce the tables if possible.

Problems

1. A month is to be represented as an integer. A valid month is in the range of 1..12. An integer < 1 is invalid, or an integer > 12 is invalid. Consider how this can be simplified or reduced.
2. An employee is either hourly or salaried. An hourly employee is paid by calculating an hourly wage and an hourly employee that works more than 40 hours is paid overtime. An hourly employee that works less than 40 hours must produce an absence report. A salaried employee can work any number of hours.
3. A new program to determine parking rates is to be developed. Users will select (from a dropdown) the classification of the vehicle owner (faculty/staff or student), the location of the parking (garage or open lot) and the type of vehicle (large or small).  Students with a small vehicle pay $250.00 in a lot and $350.00 in a garage.  Students with a large vehicle may park in a lot for $400.00.  Faculty/staff may park small vehicles anywhere for $150.00 and large vehicles in a lot for $200.00.  Large vehicles are not allowed in the garage.