Create a view containing the hotel name and the names of the guests staying at the hotel.

What will be an ideal response?


CREATE VIEW HotelData(hotelName, guestName)
AS SELECT h.hotelName, g.guestName
FROM Hotel h, Guest g, Booking b
WHERE h.hotelNo = b.hotelNo AND g.guestNo = b.guestNo AND

b.dateFrom <= CURRENT_DATE AND
b.dateTo >= CURRENT_DATE;

Computer Science & Information Technology

You might also like to view...

Which of the types listed below can be used as the type of the result value returned by a user-defined function (using a return statement)?

a. int b. double c. char d. float e. Any of the above.

Computer Science & Information Technology

What is a component?

a. It is a subgraph in which any two vertices are connected to each other by paths, and which are connected to no additional vertices in the supergraph b. It is any subgraph of a given graph c. It is a path of edges and vertices wherein a vertex is reachable from itself d. It's a plane divided into separate parts by the planar graph

Computer Science & Information Technology

The statistical graph that summarizes the distribution of data and how the data fits into defined bins is a ________

A) histogram B) bin C) kurtosis D) sample variance

Computer Science & Information Technology

COGNITIVE ASSESSMENT If someone you know is purchasing word processing software, what features can she expect to find in the software?

A. wordwrap, spell checker, clip art B. search and replace, word adjust, collaboration C. columns, templates, autowrite D. mail merge, wrapcheck, thesaurus

Computer Science & Information Technology