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.
You might also like to view...
A report provides a professional, printed format of information contained in a database
Indicate whether the statement is true or false
Answer the following statements true (T) or false (F)
1) A GUI allows the user to interact with the program visually. 2) A ComboBox can display info and also have the user input info. 3) A Label allows input to be typed into it. 4) ListBoxes and ComboBoxes are the same other than the fact that ComboBoxes have a drop-down list.