Create a view containing the account for each guest at the Grosvenor Hotel.
What will be an ideal response?
CREATE VIEW BookingOutToday
AS SELECT g.guestNo,g.guestName,g.guestAddress,r.price*(b.dateTo-b.dateFrom)
FROM Guest g, Booking b, Hotel h, Room r
WHERE g.guestNo = b.guestNo AND r.roomNo = b.roomNo AND
b.hotelNo = h.hotelNo AND h.hotelName = ‘Grosvenor Hotel’ AND
b.dateTo = CURRENT_DATE;
You might also like to view...
What is the goal of a VPN tunnel?
What will be an ideal response?
Which of the following is a possible problem when a wireless device intermittently disconnects from the AP?
A. duplicate SSID B. mismatched preshared key C. MAC address is being filtered D. disabled wireless adapter
Evaluate some of the innovative payment mechanisms that can be targeted by cyber criminals
What will be an ideal response?
In a sentinel-controlled while loop, the body of the loop continues to execute until the EOF symbol is read.
Answer the following statement true (T) or false (F)