Review Questions

1.

State two major reasons why field specifications are important.

2.

What do you gain by establishing field-level integrity?

3.

What are the three categories of elements in a field specification?

4.

Name the three types of specifications.

5.

Why is it beneficial for you to compose a proper field description?

6.

What does the Data Type element indicate?

7.

What does the Character Support element indicate?

8.

What is the purpose of the Display Format element?

9.

What types of keys are indicated on a field specification?

10.

True or False: A null represents a blank value.

11.

What is the significance of the Range of Values element?

12.

What is the purpose of an Edit Rule?

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.