Database Design for Spa/Hotel Booking System
The WR (Woodlands Retreat) is a medium sized organization currently intending to build a database system to integrate modern IT (information systems) in its business operation to enhance its dynamic and innovative business operations. Although, the Woodlands Retreat has an IT system, however, the current systems are not capable of keeping book records as well as not capable of managing all data for the company new added facilities.
Objective of this project is to build a relational database for the Woodlands Retreat using a SQL database methodology. The project provides the important assumption, and business constraints related to the project.
: Assumptions and Business Constraints
The document provides the assumption and business constraints on the baseline up which the project will be accepted. The methodology used to complete the project is SQL methodology. Moreover, the database will be designed to enforce the restriction and business rule in order to prevent double booking and over scheduling as well as enhancing effective administration.
The project provides the following assumption for the database design:
Stakeholders will not modify the project scope,
Availability of a hardware and software platform,
The hardware will be functional to enhance effective implementation of the database.
The project should be completed by the specified date and must be in line with the specified database technology.
The entire document used to design the database will be in English, and translation could be implemented only after the acceptance of English version document.
Moreover, the project must follow the following constraints in the database design.
The database will be designed in such as way that it will:
allow only one guest or group to book a venue at a time, mandate guests to pay a deposit for each booking before transaction is approved, only allow guests to book an event or venue for maximum 5 days a week, only allow a restaurant to have no more than 6 different menus.
Allow a minimum of two nights stay per booking and maximum of 7 nights per booking,
Allow "a maximum of 10 spa sessions per booking."
Additionally, the employee ID should be unique and birthday information must be in a format such as MM/DD/YEAR. (Hernandez, 2003). Moreover, each customer should have his or her unique ID different from the ID of other customer.
Moreover, a guest could only make a reservation for a period and events could only be done for private function such as birthday parties, weddings or corporate functions. Staff could be assigned specific tasks required by the guests. The client is required to have a single invoice when checking out and the system will keep tracks of staff hours in order to generate rotas.
2: Design of Enhanced Entity Relation Diagram
This section provides the EERD (Enhanced Entity Relation Diagram) for the database of the Woodlands Retreat. Enhanced entity relation model is a conceptual data model used to design a database system. The EER model is used to create an accurate database system by using database schema to simplify more complex database application system. (Stephens, & Plew, 2001). Typically, the EER model includes superclasses, primary keys, aggregation and composition in the entity relation diagram. The EER model also includes specialization, and generalization in the database design. (Navathe, 2011).
Using the ERR model, the project provides the enhance entity relations diagram for Woodlands Retreat. Identification of all entities is very critical for the enhanced entity relation diagram. Fig 1 provides the enhanced entity relation diagram for the Woodlands Retreat. The entities for the Woodlands Retreat Database are as follows:
Woodland Retreat
Clients
Accommodation
Restaurants
Moonlight
Gym facilities
Booking
Gold Suites
Employee
Payment
Rooms, and Events.
Fig 1: Enhanced Entity Relation Diagram for the Woodlands Retreat
3:Physical Design Tables
Column
Primary
Key
Foreign
Key
Alternate
Key
Data type & size
Allowable
value
Description
Derived
Data
Notes/
assumpt
Wooodland_Retreat
Wooodland_Retreat
Hotel
Address
VARCHAR (20)
10
Woodland retreat info
Address
Complete
Client
Client_ID
Client_Name
Email_ID
VARCHAR (20)
12
Set of Customer ID
E-mail ID
Complete
Employee
Employee_ID
Job_Title
Email_ID
VARCHAR (20)
8
Set of Employee ID
Email_ID
Complete
Booking
Booking _ID
Booking_reference
Customer_ID
VARCHAR (20)
7
Set of Booking Info
Customer_ID
Complete
Accommodation
Accommodation_ID
Accomodation_reference
Customer_ID
VARCHAR (20)
9
Set of Accommodation Info
Customer_ID
Complete
Restaurants
Restaurants_ID
Restaurants_reference
Wooodland_Retreat
VARCHAR (20)
11
Set of Restaurants
Wooodland_Retreat
Complete
Room
Room_ID
Room_Reference
Wooodland_Retreat
VARCHAR (20)
15
Set of Room
Wooodland_Retreat
Complete
Event
Event_ID
Event_Reference
Wooodland_Retreat
VARCHAR (20
13
Set of Event
Wooodland_Retreat
Complete
Gold Suite
Gold_Suite_ID
Gold_Suite _Reference
Wooodland_Retreat
VARCHAR (20
However, management needs to keep in mind a budget in order to make this possible (Bolman & Deal, 2008). A way in which to get everyone to work together the organization can form teams under each division. Each team has a leader that reports to the manager and communication improves because of it. They can also have teambuilding activities once a quarter to help bring about unity, which will empower
" (2000) There are other factors associated with change that enhance the ability for the independent hotels to compete as there is a segment of customers with the desire to discover for themselves what best satisfies their taste. The independent hotels offer guests "the option of maintaining their differentiation while affiliating with 'soft' brands, which reflect a defined product and offer similar service support as franchisers or chains." (Swig, 2000)
TQM Total Quality Management A Look into how the Ritz Carlton Hotel Chain uses Total Quality Management to Address Quality of Service Issues Company Background Level of Service Required for World Class Service Total Quality Management in a Service Environment Human Resource Role in Service TQM The Ritz Carlton's hotels are focused on a rather narrow target market that expects world class facilities as well as world class service by the hotels staff. While constructing world class
In this regard, Higgins (2002) reports that Micros Systems Inc. introduced a custom application specifically for the hospitality industry early on, and despite the lingering effects of the September 11, 2001 terrorist attacks on the market, this company and others such as BDM International Inc. are continuing their efforts to provide hotels, restaurants and other organizations competing in the hospitality industry with the information technology they need to become
Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.
Get Started Now