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;

Computer Science & Information Technology

You might also like to view...

What is the goal of a VPN tunnel?

What will be an ideal response?

Computer Science & Information Technology

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

Computer Science & Information Technology

Evaluate some of the innovative payment mechanisms that can be targeted by cyber criminals

What will be an ideal response?

Computer Science & Information Technology

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)

Computer Science & Information Technology