Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition

Summary

This chapter began with an explanation of why terminology is important for defining, discussing, or reading about the relational database model and the database-design process.

The section on value-Related Terms showed you that there is a distinct difference between data and information, and that understanding this difference is crucial to understanding the database-design process. You now know quite a bit about nulls and how they affect information you retrieve from the database.

Structure-related terms were covered next, and you learned that the core structures of every relational database are fields, records, and tables. You now know that views are virtual tables that are used, in part, to work with data from two or more tables ...