Using relational algebra, create a view of all rooms in the Grosvenor Hotel, excluding price details. What would be the advantages of this view?

What will be an ideal response?


? roomNo, hotelNo, type (Room hotelNo (? hotelName=‘Grosvenor Hotel’ (Hotel)))
Security - hides the price details from people who should not see it.
Reduced complexity - a query against this view is simpler than a query against the two underlying
base relations.

Computer Science & Information Technology

You might also like to view...

A structure variable is a collection of smaller values called ____________ values

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

The ________ is used to setup a maintenance plan for running system tools

Fill in the blank(s) with correct word

Computer Science & Information Technology

Which of the following is NOT true in regard to adding command buttons to the navigation form?

A) Command buttons can be added to forms and reports that are accessed through the navigation form. B) Buttons are more intuitive than the navigational arrows at the bottom of a form. C) Instead of requiring the user to use the selection arrows and navigation buttons on a form, you can insert buttons with navigation and selection commands for them to use. D) If you are adding command buttons, you must disable the navigational arrows at the bottom of the form or the command buttons will not work properly.

Computer Science & Information Technology

When writing a program, a(n) ____ structure provides the ability for the same operation to be repeated based on the value of a condition.

A. sequence B. selection C. iteration D. invocation

Computer Science & Information Technology