The following tables form part of a database held in a relational DBMS:
Hotel (h)hotelNo, hotelName, city
Room (r)roomNo, hotelNo, type, price
Booking (b)bookingNo, hotelNo, guestNo, dateFrom, dateTo, roomNo
Guest (g)guestNo, guestName, guestAddress
where the bolded attributes are the primary keys for the respective tables. Using theabove tables, answer the following questions:
4. Create a separate table with the same structure as the Booking table to hold archive records.
5. Using the INSERT statement, copy the records from the Booking table to the archive table relating to bookings before 1st January 2021.
6. Delete all bookings before 1st January 2021 from the Booking table.