Can you provide the above design in third normal form (3NF) or higher . Can I get explanation and 3NF diagram . 

 

Transcribed Image Text:

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 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