Answered step by step
Verified Expert Solution
Question
1 Approved Answer
GIVE ME PHYSICAL MODEL FOR THIS DIAGRAM USING 3NF PK Review review ID * Rating Level o Type of trip [0..n] * Date of review
GIVE ME PHYSICAL MODEL FOR THIS DIAGRAM USING 3NF
PK Review review ID * Rating Level o Type of trip [0..n] * Date of review o Liked [0..n] o Disliked [0..n] o Description o Nights Stayed o Month Stayed o Like Count PK Hotel Amenity Details hotel amenity detail ID o Popular o Location Type [0..n] o Price Per Night o Hours Available [0..n] + HH PK PK PK Amenity amenity ID * Category Name Hotel hotel ID * Name o Star Rating / Review Rating / Review Count o Policies [0..n] Address PK address ID * street address * * City/Town * Postal Code * Country * Phone Number Guest review ID * First Name * Last Name * Email Address ||| |++ PK PK Bed Type bed type ID * Size * Type Sleeps Count Room room ID * Name o Room Type / Sleeps Count Reservation PK reservation ID * Check In Date Check Out Date * Check In Time *Number of Adults * Number of Children /Average Nightly Rate / Taxes / Total Price TH Rate Plan PK rate plan ID PK * Name * Nightly Rate * Payment Due Type Refundable Type Credit Card card number * Expiration Date
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started