Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
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 books? |
| 16: | Why must you complete a View Specifications sheet for every view in the database? |
| |
| Top |