Write PL-SQL procedures, Write PL/SQL procedures for the

Write PL-SQL procedures

Assignment Help PL-SQL Programming

Reference no: EM131969883

Assignment Task -

Write PL/SQL procedures for the following:

1. Show available rooms by type: Given a hotel ID, display the count of all available rooms by room type.

2. Room Checkout Report: Input: ReservationID Output:

Guest name
Room number, rate per day and possibly multiple rooms (if someone reserved several rooms)
Services rendered per date, type, and amount
Discounts applied (if any)
Total amount to be paid

3. Income By State Report: Input is state. Print total income from all sources of all hotels by room type and service type in the given state. Include discounts.

Requirements

If a hotel is booked in the months of May-August, the charge is $300. Otherwise, it is $200. All room types are charged the same rate. The rate is based on the first date of check-in, and is the same throughout the guests stay.

If the guest reserves a room 2 months in advance or more, they get a 10% discount

Guests can check in without a reservation

The services that are offered by all hotels are the same.

They include:

a. Restaurant services (assume $20 per person per meal)

b. Pay-per-view movies (assume $5 per movie)

c. Laundry services (assume $10 per time - regardless of number of items).

Reference no: EM131969883

Questions Cloud

Create a relational database in microsoft access : BUS5BID - Management and Marketing Business Information Systems Design - Create a user manual for your Choice appointments Information System

How to develop relationships with your stakeholders : Post a 260- to 350-word response to the following: How do you create and develop relationships with your stakeholders?

Explain community health nursing and public health nursing : Explain any relationship between Community health nursing and Public Health Nursing and mention and discuss any relationship between both terms.

Prepare a introduction letter about the course : The first step in choosing a mentor is determining what you want to accomplish. A mentor who can challenge your thought process and beliefs is helpful.

Write PL-SQL procedures : Write PL/SQL procedures for the following: Show available rooms by type: Given a hotel ID, display the count of all available rooms by room type

What strategies organization put in place to prevent penalty : For the first half of the quarter, we have been discussing how to build an appropriate HRIS. You can view these as the building blocks for a sustainable HRIS.

Result of the increased competition : Suppose the number of firms you compete with has recently increased. You estimated that as a result of the increased competition, the demand elasticity

What are your marginal costs for each customer load level : Suppose your company runs the shuttle business for a hotel to and from the local airport. The costs for different customer load are:

Explain two normal health patterns of the client : Explain two normal health patterns of the client as well as two abnormal health patterns that you observe, and provide examples.

User Account

All Pages