Star Inn is a chain of hotels. The reservation system is uses a centralized reservation database. The database contains booking information on all hotels of Star Inn. The following is a description of the conceptual model of the hotel reservation database at Star Inn.

The database contains information about hotels, hotel rooms, customers, and reservation. A hotel can be identified by its identification number (hotel_id). It is also described by hotel_name, address and phone_no. Rooms are identified by room_no which is unique for a hotel. The same room_no may exist in different hotels of Star Inn. Rooms are also described by type and rate.

Customers are identified by customer_id and are described by name (customer_name), address (customer_address), and phone number (customer_phone). When a customer makes a reservation, he/she is asked to specify the hotel, the room type, the arrival date (arrival_date) and duration of stay (duration). A specific room is then booked for the customer. A customer can book the same room more than once. Therefore, a reservation is identified by a reservation number (reservation_no).

Please use Visible Analyst or any other CASE tool to draw the ERD.

Fun City has decided to build a new municipal water park with pools, water slides, and so forth. You have been hired to conduct a study to determine if the water park can pass the test. A nearby and very similar city currently has a water park similar to the one Fun City is considering. The nearby city currently charges $10 for admission and, on a typical day, attracts 4,000 persons. Last year, it charged $15, but only attracted 3,000 paying customers.

1. Assuming that the demand curve for water parks is linear, estimate the net benefits received by those using the Fun City water park, if Fun City charges an admission price of $12.50. [NOTE: You need not compute the actual amount; just use a graph and clearly indicate the area that represents the net benefit amount.]

2. By how much, and in what direction, would the net benefits received by those using the water park change if Fun City charges a $15.00 admission price, rather than $12.50? [NOTE: This time compute the actual dollar value.]

IN JAVA

Write a program that calculates the occupancy rate for each floor of a hotel. (Use a sentinel value and please point out the sentinel in bold.) The program should start by asking for the number of floors in the hotel. A loop should then iterate once for each floor. During each iteration, the loop should ask the user for the number of rooms on the floor and the number of them that are occupied. After all the iterations, the program should display the number of rooms the hotel has, the number of them that are occupied, the number that are vacant, and the occupancy rate for the hotel. Input Validation: Do not accept a value less than 1 for the number of floors. Do not accept a number less than 10 for the number of rooms on a floor.

SAMPLE OUTPUT:

Enter number of floors:
2
Enter total rooms at floor 1:
10
Enter total rooms occupied at floor1:
5
Enter total rooms at floor 2:
10
Enter total rooms occupied at floor2:
5
Total rooms: 20
Total occupied rooms: 20
Hotel occupany: 50.0

Consider a firm that has just built a plant, which cost $1,000. Each worker costs $5.00 per hour. Based on this information, fill in the table below.

A quality control activity analysis indicated the following four activity costs of a hotel.

Sales are $7,700,000 for the year. Prepare a cost of quality report.

Present percentage values to one decimal place.

4. Mrs Garcia, a physics enthusiast, goes to a water park in South Padre Island to test the concepts learned during class. She goes on a water slide that is 265 meters long and is built at an angle with the ground of θ = 30 degrees. – What is her final velocity at the end of the slide?

5. A goalkeeper kicks a soccer ball that is initially resting on the ground. She kicks the ball with an initial velocity of 8 m/s. The initial angle between the ground and the trajectory of the ball is θ=27 degrees. – How long is the ball in the air? – How far does the ball travel? – How high does the ball go? Hint: Use equations of motion and the definition of range and maximum height for projectile motion.

6. Solve the following quadratic equations: 2x 2 + 6x + 1 = 0 (1) 4x 2 + 12x + 2 = 0 (2) 9x 2 − 4x + 12 = 0 (3) (x − 1) x + 3 + 3 (x − 1) = (4 − x) (x − 1)(x − 1) (4) Hint: Factor and simplify using (x − 1).

(a) The daily demand for hotel rooms in Greater Toronto Area (GTA) is given by the equation: QD = 230–35P. The daily supply of hotel rooms GTA is given by the equation: QS = 13+19P. What are the equilibrium price and the quantity of hotel rooms? 6 marks

(b) Suppose the demand for a bushel of Corn in 2000 was given by the equation QD = 2550–166P. At a price of $4.46 per bushel, what is the price elasticity of demand? If the price of Corn falls to $4.27 per bushel, what happens to the revenue generated from the sale of Corn?

A hotel downtown is trying to implement an employee recognition program based on a standardized problem solving test. The company administering the test indicated that the scores are normally distributed with a mean of 82 points, and a variance of 16. The hotel has decided that employees who score in the bottom 7.5% of the test scores will not receive any additional benefits. The manager would like to know:

a. The probability that an employee would score between 70 and 78 points

b. What cutoff score on the test should the hotel use to not give any additional benefits?