subject:DBMS(database management system)

a) Create a view to check the hotel name, room number and the guest names who booked the room

b) Select everything from the view created above

c) Drop the above view

d) Create a view to check the hotel number and hotel names and the number of rooms they have.

e) Create a view to see the pair of room types and prices.

f) Create a view to see the distinct pair of room types and prices.

g) Create an index of room types and prices on the room table

h) Drop the above index

i) Create an index of the guest names

j) Create a new table including hotel information (i.e., hotel names and numbers) from the room table

k) Backup the room table

l) Insert the staff numbers and names as the guest numbers and names into the guest table. If not successful, why?