Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write an SQL for this schema below ? Feedback table [ [ feedback - id , rating,comment,reservation _ id ] ] Guests table

Write an SQL for this schema below ?
Feedback
\table[[feedback-id,rating,comment,reservation_id]]
Guests
\table[[guest-id,phone_num,address,email,name]]
Reservations
\table[[reservation-id,check-in-date,Check-out-date,guest-id,Bill-id]]
Invoice
\table[[bill-id,Payment_method,amount,date,guest-id]]
Rooms
room-id
room-num
room-status
floor_num
guest-id hotel-id
Hotel
\table[[hotel-id,hotel_location,hotel_address]]
Employees
\table[[emp-id,address,salary,hotel-id]]
Fills
\table[[feedback-id,guest-id]]
Makes
\table[[guest-id,reseryation-id]]
Suite
\table[[room-id,room-num,room-status,floor-num,CarParkingSpot]]
Single-Room
\table[[room-id,room-status,room-num,floor-num]]
Deluxe room
\table[[room-id,room-num,room-status,floor-num]]
Receptionist
emp-id
Maintenance
Admin
Super-emplD
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MFDBS 91 3rd Symposium On Mathematical Fundamentals Of Database And Knowledge Base Systems Rostock Germany May 6 9 1991

Authors: Bernhard Thalheim ,Janos Demetrovics ,Hans-Detlef Gerhardt

1991st Edition

3540540091, 978-3540540090

More Books

Students also viewed these Databases questions