Individual: SR-bi-003 – Hotel Database, Part 3

CompleteService Request SR-bi-003 - Hotel Database–Part 3.

·  Normalizethe entities and attributes to at least the third normal form.

·  UseMicrosoft®Visio®diagramming tools to create an entity-relationship diagram (ERD) that demonstrates the logical design of your normalized database.

·  Createand alter tables in the city’s Oracle®Database Express®database to implement the ERD design.

·  Generatea new DDL script.

Createa fax cover sheet addressed to the project manager for the ERD and a newly generated DDL script to show your progress on the project.

Background

The resort has three hotels. The hotels were built at different times and they cater to different market segments. Over the years, the hotels have had a series of different owners, each using different management practices and using different business systems. Currently, the hotels each have separate management, but Boardman Management Group is coordinating overall management to maximize the efficiencies and profits of the properties. Each hotel has a different way of keeping track of room inventories, guest charges, and room maintenance. The systems range from a paper folio system to a proprietary computerized hotel management system. A key step in Boardman's coordinated management of the hotels is to have all of the hotels using the same database to track room inventories, guest charges, and room maintenance.
Approximately 1 year ago, the Boardman Management Group started a project to create the hotel database. The project was awarded to a technology consultant in Kelsey. With the downturn in the economy, the technology consultant encountered financial difficulty and was unable to complete the project. The only documentation the client has from this earlier attempt is a partial set of tables under Compiled Entities and Attributes. It appears that the consultant may have been trying to adapt software written to manage an apartment complex.

Compiled Entities and Attributes:

Room_Type /
Description
Family
Kitchenette
Room_Type
Hotel
City
Description
Hotel_ID
Housekeeping_Phone
Housekeeping_Supervisor
Housekeeping_Supervisor_Employee_ID
Manager
Manager_Employee_ID
Name
Phone
Street_Address
Zip
Rooms /
Amenity1
Amenity2
Hotel_ID
Room_Description
Room_ID
Room_Number
Room_Price1
Room_Price2
Room_Price3
Room_Type
Smoking