Views - Database Design for Mere Mortals - page 399

Review Questions
1 . Why can you refer to a view as a virtual table?
2 . State two reasons why views are valuable.
3 . Name the types of views you can define as you design the logical structure of the
database.
4 . What does your RDMBS do each time you access a data view (or any type of view,
for that matter)?
5 . What determines the type of modifications you can make to a view's data?
6 . What is the only requirement you must fulfill in order to define a multitable data
view?
7 . Why doesn't a data view contain its own primary key?
8 . What is the purpose of an aggregate view?
9 . What are the most common aggregate functions that you can apply to a set of data?
10 . What is a grouping field?
11 . True or False: You can modify the data in an aggregate view.
12 . What is the difference between a validation table and a validation view?
13 . Name two points you would consider when identifying view requirements.
14 . When should you use calculated fields?
15 . How do you define a view that displays only science-fiction topics?
16 . WhymustyoucompleteaViewSpecificationssheetforeveryviewinthedatabase?