. Create a view containing the hotel name and the names of the guests staying at the hotel. 2. Create a view containing the account for each guest at the Grosvenor Hotel. 3. Give the user Manager full access to the above 2 views, with the privilege to pass the access on to other users.
The following tables form part of a
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:
1. Create a view containing the hotel name and the names of the guests staying at the hotel.
2. Create a view containing the account for each guest at the Grosvenor Hotel.
3. Give the user Manager full access to the above 2 views, with the privilege to pass the access on to other users.
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.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
