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)