Chapter 13. Reviewing Data Integrity | Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design

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 books?
16:	Why must you complete a View Specifications sheet for every view in the database?

Top