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 ...

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.