Review Questions

1.

Why is terminology important?

2.

Name the four categories of terms.

3.

What is the difference between data and information?

4.

What does a null represent?

5.

What is a null's major disadvantage?

6.

What are the chief structures in the database?

7.

Name the three types of tables.

8.

What is a view?

9.

State the difference between a key and an index.

10.

What are the three types of relationships that can exist between a pair of tables?

11.

What are the three ways in which you can characterize a relationship?

12.

What is a field specification?

13.

What three types of elements does a field specification incorporate?

14.

What is data integrity?

15.

Name the four ...

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.