City

idname
1New York
2Los Angeles
3Chicago
4Houston
5Phoenix

Hotel

idnameaddresscity_id
(→ City.id)
1The PlazaCentral Park South, New York, NY 100191
2Beverly Wilshire9500 Wilshire Blvd., Beverly Hills, CA 902122
3Palmer House Hilton17 E Monroe St., Chicago, IL 606033
4Marriott Marquis Houston1777 Walker St., Houston, TX 770104
5Fairmont Scottsdale Princess7575 East Princess Dr., Phoenix, AZ 850545

RoomType

idhotel_idtypeprice
(→ Hotel.id)
11Standard250
21Deluxe300
32Luxury Suite700
43Executive Suite400
54Family Suite250
65Garden View200

LeisureFeature

idfeature
1Swimming Pool
2Hot Tub

FeatureInRoom

idroomtype_idleisurefeature_id
(→ RoomType.id)(→ LeisureFeature.id)
111
222
331
442
551

Reservation

idcheckin_datecheckout_dateroomtype_idcustomer_nameguest_count
(→ RoomType.id)
12023-01-012023-01-051John Doe2
22023-01-102023-01-152Jane Smith3
32023-02-012023-02-053Alice Johnson1
42023-02-102023-02-154Bob Brown2
52023-03-012023-03-055Carol White1