Database System Design and Implementation

Running head: DATABASE SYSTEM DESIGN AND IMPLEMENTATION
Database System Design and Implementation
Name of the Student
Name of the University
Author’s note:

DATABASE SYSTEM DESIGN AND IMPLEMENTATION1
Table of Contents
Introduction:....................................................................................................................................2
Background of the organization:.....................................................................................................2
Task 1:.............................................................................................................................................4
Task 2:.............................................................................................................................................6
Task 2.1:......................................................................................................................................6
Task 2.2:..........................................................................................................................................7
Task 2.3:........................................................................................................................................11
Task 2.4:........................................................................................................................................12
Task 2.5:........................................................................................................................................13
Conclusion:....................................................................................................................................15
Bibliography:.................................................................................................................................16

DATABASE SYSTEM DESIGN AND IMPLEMENTATION2
Introduction:
The following report is all about ABC hotel which is a family owned hotel located in
Leicester. Beginning from hotel purely that is for individual customer for booking to overnight
stay. It has ultimately grown into a business which aims to offer different kind of hotel based
services to most of its clients. The manual approach for booking to these services has become
very much difficult in nature. Staff are finding the rooms at much frequent rate which is used in
more than one service and even a single room is being booked twice. It is considered to be as one
of the major issue that is impacting the overall reputation of hotel and its services. Oracle DBMS
comes up with list of features that makes it popular in the whole business world. The current
version of oracle DBMS are being released which comes up with new and enhanced features.
This will merely be used for geared for both business and corporation. In the whole market,
Oracle is found to have leading role as a result of persistence for providing the perfect database.
In the coming pages, an idea has been provided with respect to background of this ABC hotel.
After that, conceptual database and logical database design has been given.
Background of the organization:
ABC Hotel is a family owned hotel that is based in Leicester. Beginning from pure hotel
serving individual customers, the organization has grown into a business which provides hotel
based service to clients. ABC hotel takes up booking for weeding, business events and parties
along with individual stay in the hotel. All the booking is done come up with a particular date
and booking time along with particular booking code. In addition, it has the name of the staff
member that took up the booking and credit card details. The remaining amount needs to be
settled on very last day of the event at the hotel. A record is maintained for the payment method

DATABASE SYSTEM DESIGN AND IMPLEMENTATION3
which is being recorded alongside of paid amount. Booking for weeding reception is mainly
done one day prior to the actual date of booking. All these booking is done on the telephone
where the name of the groom and bride is being recorded with client detail.
The booking is merely inclusive of wedding details requirements like guest and food
menu needed by the reception. It will merely facilities the wedding and special request which is
needed for decorating weeding rooms. Booking of the business event also requires the same kind
of client detail which needs to be stored. Along with this, the name and registered address of the
business organization is taken into account. ABC has five small meetings which is booked as a
part of the business booking event.