1) Create table Room Reservation for hotel management system a. Assume that the hotel classify rooms...

Transcribed Image Text:

1) Create table Room Reservation for hotel management system a. Assume that the hotel classify rooms by the number or size of beds in the room, and there are only 6 room types: Queen, King, Twin, Hollywood twin, Double-double and Studio. Therefore, apply check constraints on RoomType column; b. ReservationID is the primary key C. GuestEmail should not be NULL d. Departure date should not be earlier than the arrival date COMP122- Introduction to Database Concepts Pg. 6 e. Name all constraints properly 2) Insert two rows to the newly created table 3) Alter the table by adding guest name and guest address 4) Set specialRequests columnas Unused... and then remove all unused columns.. 5) Modify numGuests column as NUMBER(2) and set NOT NULL RoomReservation P ReservationID Room Type * GuestEmail bookingDate: arrivalDate departure Date numGuests NUMBER (10) VARCHAR2 (10) VARCHAR2 (100) DATE DATE DATE NUMBER (1) special Requests VARCHAR2 (250) RoomReservation_PK (ReservationID) 1) Create table Room Reservation for hotel management system a. Assume that the hotel classify rooms by the number or size of beds in the room, and there are only 6 room types: Queen, King, Twin, Hollywood twin, Double-double and Studio. Therefore, apply check constraints on RoomType column; b. ReservationID is the primary key C. GuestEmail should not be NULL d. Departure date should not be earlier than the arrival date COMP122- Introduction to Database Concepts Pg. 6 e. Name all constraints properly 2) Insert two rows to the newly created table 3) Alter the table by adding guest name and guest address 4) Set specialRequests columnas Unused... and then remove all unused columns.. 5) Modify numGuests column as NUMBER(2) and set NOT NULL RoomReservation P ReservationID Room Type * GuestEmail bookingDate: arrivalDate departure Date numGuests NUMBER (10) VARCHAR2 (10) VARCHAR2 (100) DATE DATE DATE NUMBER (1) special Requests VARCHAR2 (250) RoomReservation_PK (ReservationID)

Answer rating: 100% (QA)

Heres how you can create the RoomReservation table for a hotel management system based on your requirements and perform the specified tasks 1 Create t... View the full answer