Question: 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
 Write an SQL for this schema below ? Feedback \table[[feedback-id,rating,comment,reservation_id]] Guests

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!