Su Question 30 35 P For The Following Hotel Database Schema Write Sql Queries To Answer The Following Points Reservati 1 (40.89 KiB) Viewed 47 times
Su Question 30 35 P For The Following Hotel Database Schema Write Sql Queries To Answer The Following Points Reservati 2 (40.89 KiB) Viewed 47 times
SU Question 30 35 p For the following Hotel database schema, Write SQL queries to answer the following points: Reservation Customers PK on NOT NULL customer_id int NOT NULL PK customer id NOT NULL oFK1 customer name char(50) NOT NULL room no it NOT NULL checkout, dale de NOT NULL checkout didedale NOT NULL room faces char(50) NOT NULL 1. Retrieve the name of all customers who have reservation with check in date 20-June-2022 2. Retrieve the name of all the customers who have reservation for a room type "Double" and the check out date is before 1-july-2022 3. Add a new reservation for customer with id-5 for a room number -202 from 25-June-2022 to 28-June-2022. (The reservation id will be 2030) For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). IXO AV Open Sans,s... V 10pt V US Paragraph Rooms PK room no int NOT NULL FK1 room type int NOT NULL !!! H
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!