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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.