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...
Which data type should be applied to numbers that will not be used in calculations?
a. Criteria b. Currency c. Number d. Text
Computer Science & Information Technology
Picture styles include all of the following EXCEPT ________
A) 3-D rotation B) borders C) shadows D) frames
Computer Science & Information Technology