Chapter 3

  1. Terminology is important for the following reasons:

    a. It is used to express and define the special ideas and concepts of the relational database model.

    b. It is used to express and define the database-design process itself.

    c. It is used anywhere a relational database or RDBMS is discussed.

  2. The four categories of terms are value-related, structure-related, relationship-related, and integrity-related.

  3. The values you store in the database are data. Information is data that you process in a manner that makes it meaningful and useful to you when you work with it or view it.

  4. A null represents a missing or unknown value.

  5. The major disadvantage of nulls is that they have an adverse affect on mathematical operations.

  6. Tables are the chief ...

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.