Encerrado

Hotel Reservation System

Hi

I`m designing a hotel reservation system using oracle. I need someone to create the **'front end' using Oracle Developer 6**.I`ve attached the design document(Requirements Document and Data Flow Diagrams). If you need more details please email me.

## Deliverables

**Introduction:**

This document reports in detail the functional requirements of the Hilton Reservation Network (HRN).

**Making a New Reservation:**

HRN handles three types of reservations:

1. Regular

2. Block

3. Package

**The Mandatory information required for making a reservation:**

1. Hotel Name

2. Booking Type (Confirmed Regular/Confirmed with Advance Paid etc)

3. Arrival and departure dates

4. Reservation Type (Regular/Pack/Block)

5. Room Type and Occupancy (Single/Double)

6. Market segment

7. Guest Last Name

8. Reservation assistant’s last Name

9. Guest Address

10. Guest Telephone number

11. City and country

12. Billing instructions and purpose of visit

**Regular Booking:**

**Business Model for making Regular Reservation**

1. Customer enquires for the availability of room in a particular hotel for a specific set of dates

2. The reservation assistant queries the status for the rooms for the specified dates:

If the status for all the days the customer has requested for are **Open** then he is been given a **Confirmed reservation**, else if any of the days requested are **On Request** then he gets a **On Request** **reservation**, else if any of the days are **Closed** then he gets a **Waitlisted reservation**.

**3. ** Customer places a request for reservation based on the status by specifying the **desired Rate** and **Billing Instruction.**

4. The reservation assistant selects the **Market segment** (company for a corporate booking, TA for travel agent and Individual for an Individual traveller).

5. The customer specifies the **personal information** such as name, address etc. The customer informs the reservation assistant regarding any special preferences he needs when he checks into the hotel.

6. The reservation assistant makes the reservation request by giving the customer a **unique reservation number** for future reference.

**Block Booking:**

**Business model for Block Booking:**

1. Customer enquires for **Block booking** in a particular hotel for a specific set of dates and specifies the Rate Type as well as the billing instruction.

2. Customer specifies the **room types** and room counts for each type of requested room.

3. The reservation assistant queries for status on all rooms specified for requested days. If any of the rooms on any of the requested days have a **closed** status then the over all booking status will be waitlisted. If any of the rooms on the requested days have an **On Request** status then the over all booking status will not be confirmed unless the hotel confirms it. If and only if both the above mentioned cases fail then only a **confirmed booking status** will be given. The statuses for individual rooms are applied like the regular reservation.

4. The customer specifies the **personal information** such as name, address etc. The customer informs the reservation assistant regarding any special references he needs when he checks into the hotel

5. Reservation assistant then makes the reservation by giving the guest a **unique reservation number** for future reference.

Block Booking can only be done by administrator of the system.

**Package Booking:**

**Business model for Package Booking:**

1. Customer enquires for **package booking** in a particular hotel for a specific set of dates.

2. Reservation assistant checks whether the hotel offers the package requested for the specified dates.

3. Customer specifies the room types he needs and the room counts for each type of requested room. The customer can request only for rooms that are offered in the package and the minimum number of room nights that the customer request for should be the room nights offered by the package.

4. The reservation assistant queries for status on all the rooms specified for the requested days. If any of the rooms on any of the requested days have a **closed** status then the over all booking status will be waitlisted. If any of the rooms on the requested days have an **On Request** status then the over all booking status will not be confirmed unless the hotel confirms it. If and only if both the above mentioned cases fail then only a **confirmed booking status** will be given. The status for individual rooms is applied just like regular reservation.

5. The customer specifies the **personal information** such as name, address etc. The customer informs the reservation assistant regarding any special preferences he needs when he checks into the hotel.

6. Reservation assistant then makes the reservation by giving the guest **a unique reservation number** for future reference.

**Cancelling a Reservation:**

Business Rule for Cancelling a Reservation:

1. Customer asks for cancellation of a reservation by giving the unique reservation reference number.

2. Reservation assistant performs the cancellation of the particular reservation if and only if they are future reservations (cancellation must be done 2 days before check in).

3. The customer gives the reason for cancellation.

4. Reservation assistant cancels the reservation and gives the customer a Cancellation number for future reference.

**Amending a Reservation:**

Amendments are modifications done to reservations. The information that can be amended in a reservation is:

1. The room type

2. The arrival and departure dates

3. If the arrival and departure dates or the room type is modified the booking status is revised.

4. The new tariff amount will be computed based on the changes made above.

5. The guest information such as name, arrival details etc.

**Reservation Search:**

Searching for a reservation should be done on various combinations:

1. Reservation Number

2. Hotel Name

3. Arrival Date

4. Company name for a company reservation

5. Travel agent name for TA reservation

6. Guest First name/middle name/last name

7. By reservation assistant who made the reservation

8. Date of the reservation

**Sending Mail and fax to hotels:**

Details of the new reservation or cancellations or amendments should be sent to hotels on a periodic basis. The application should handle two mediums of reservations for providing this facility: Fax and Email. The information generated for each hotel will be their transactions undertaken for the day: new reservations, cancellations and amendments. The reservation assistant should be able to transfer these transactions to the hotels by fax or email.

**Report Capabilities:**

The HRN must generate the following reports in addition to its normal functions:

**Daily Transaction Reports:**

These reports are generated at the end of the day for the management personnel of the respective TRN.

| Arrival List | List of the guests who will be checking into a Hotel on the specified hotel |

| Daily Booking Report | List of Reservations (includes Cancellation, amended and New) taken for the day |

| Daily Booking Report (Cancelled) | List of Cancelled reservations taken for the day |

| Daily Booking Report (Confirmed) | List of Confirmed new reservations |

| Daily Booking Report (Waitlisted) | List of waitlisted reports taken for the day |

| Daily sales report | A consolidated report to list the sales (new/ cancelled/ amendment) done for the day |

| Payment Details report | List of reservations for which advance was received |

**Monthly Reports**

Monthly reports are taken every month for the management personnel. These reports are taken once the materialisation is being performed for the month. Materialisation is the month close operation where for each hotel how many bookings were taken and out of it how many were confirmed and how many were cancelled. This also performs an analysis based on the market segments too.

| Consolidated Nationality Report | List of the Nationalities of the guests who have made visiting purpose of guests |

| Segment Report | Lists the number of rooms sold for each market segment |

| Detailed Segment Report | Lists the number of rooms sold for each market segment. This report also lists the number of rooms sold on a hotel basis. |

**Yearly Report**

These reports are taken once the year close is being performed. These reports give detailed information regarding the trend and the business done through out the year.

| Yearly Actual Room Nights | Lists the room nights materialised for each hotel. |

| Yearly Room Night report | Lists the room nights sold by TRN to each hotel. |

| Yearly Room Night / Day Report | This gives the break-up for each hotel for individual months in a year. |

Security Features:

HRN will have the following security features:

· **Authentication**

The system will provide strong user identification and authorization and offers a variety of choices for user authentication

· **Password Based Authentication:**

The system will provide built in and robust password management facilities that will enable administrators to:

§ Enforce minimal password length

§ Ensure password complexity

§ Disallow passwords that are easily guessed words

§ Lock accounts after certain number of incorrect passwords have been entered

· **Access control**

Access Control deals with the concept of who has access to what information and what type of operations can be accessed. The system will provide a strong set of access control security mechanisms through privileges. The system will grant only those privileges to a user which allows him to perform his job functions, but no more.

· **Backup and Recovery operations**

The system will also perform backup and recovery operations so that the management does not loose any information in case of breakdown of the system.

**Room Rate (Published rate):**

| Category | Number of Rooms |

| Single | 20 | £100 |

| Double | 20 | £150 |

| Triple | 20 | £175 |

Conference Rooms: £500

**Package Booking:**

The Hotel is not offering any packages to customers at the moment. The system will be updated as and when new packages are being offered to customers.

## Platform

Platform: Windows NT

Habilidades: Engenharia, MySQL, Oracle, PHP, Arquitetura de software, Teste de Software

Ver mais: who needs a personal assistant, what new on oracle business, what makes me unique, what is oracle package, what is oracle company, what is network flow, what is a personal reference, what is a network flow, what are packages in oracle, what are oracle packages, user diagrams, user case diagrams, types of searching in c, types of packages in oracle, single system design, security company sales, search for a personal assistant, sales agent requirements, sales agent job, reservation sales agent, references job application, personnel concept, personnel assistant, personal job agent, personal assistant job search

Acerca do Empregador:
( 0 comentários ) United Kingdom

ID do Projeto: #2958679

9 freelancers estão ofertando em média $3473 para este trabalho

amritb

See private message.

$4250 USD in 10 dias
(44 Comentários)
6.8
alicoder

See private message.

$106.25 USD in 10 dias
(17 Comentários)
3.7
vw926225vw

See private message.

$17000 USD in 10 dias
(0 Comentários)
0.0
vw924812vw

See private message.

$4250 USD in 10 dias
(0 Comentários)
0.0
expertsonlinevw

See private message.

$127.5 USD in 10 dias
(0 Comentários)
0.0
mostafanagy

See private message.

$850 USD in 10 dias
(0 Comentários)
0.0
oraclelover

See private message.

$2550 USD in 10 dias
(0 Comentários)
0.0
pkranjan

See private message.

$595 USD in 10 dias
(0 Comentários)
0.0
damen

See private message.

$1530 USD in 10 dias
(1 Comentário)
0.0