slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Hotels Hotel_id Country_code Hotel_name Hotel_address Hotel_city Hotel_zipcode PowerPoint Presentation
Download Presentation
Hotels Hotel_id Country_code Hotel_name Hotel_address Hotel_city Hotel_zipcode

Loading in 2 Seconds...

play fullscreen
1 / 2

Hotels Hotel_id Country_code Hotel_name Hotel_address Hotel_city Hotel_zipcode - PowerPoint PPT Presentation


  • 105 Views
  • Uploaded on

Hotel Reservation Database. Countries Country_code Country_currency Country_name. Hotel Amenities Lookup Characteristic_id Characteristic_description. Hotels Hotel_id Country_code Hotel_name Hotel_address Hotel_city Hotel_zipcode. Hotel rooms Room_number Hotel_id Room_type

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Hotels Hotel_id Country_code Hotel_name Hotel_address Hotel_city Hotel_zipcode' - penelope-herman


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

Hotel Reservation Database

Countries

Country_code

Country_currency

Country_name

Hotel Amenities Lookup

Characteristic_id

Characteristic_description

Hotels

Hotel_id

Country_code

Hotel_name

Hotel_address

Hotel_city

Hotel_zipcode

Hotel rooms

Room_number

Hotel_id

Room_type

Room_floor

Hotel Amenities

Characteristic_id

Hotel_id

Guests

Guest_number

Guest_firstname

Guest_lastname

Guest_address

Guest_city

Guest_zipcode

Guest_email

Room Bookings

Booking_id

Room_type_code

Hotel_id

Checkin_date

Number_of_days

Room_count

Guest Bookings

Booking_id

Guest_number

Room types

Room_type_code

Room_standard_rate

Room_description

Smoking_YN

slide2

HotelComplainer Ratings Database

(totally external company)

Café in the Hotel Database

(same company but database is not connected to the hotel)

Hotels

Hotel_id

Country_code

Hotel_name

Hotel_address

Hotel_city

Hotel_zipcode

Ratings

Rating_id

Hotel_id

Date_of_stay

Star_rating

Review_text

Customer

Customer_number

Customer_name

Customer_address

Customer_city

Customer_zipcode

Order

Order_number

Customer_number

Hotel_id

Food_item_id

Order_date

Order_time

Table_number

Customer

Customer_number

Customer_name

Customer_address

Customer_city

Customer_zipcode

Customer_email

Food item

Order number

Food_item_id

Order_date

Order_time

Hotel Rating

Rating_id

Customer_id

Date_of_rating

Hotels

Hotel_id

Country_code

Hotel_name

Hotel_address

Hotel_city

Hotel_zipcode