Chapter 4

  1. It is important to complete the design process thoroughly because it helps you assure a sound structure and data integrity.

  2. True. The level of structural integrity is in direct proportion to how thoroughly you follow the design process.

  3. The mission statement identifies the purpose of your database.

  4. Mission objectives are statements that represent the general tasks your users can perform against the data in the database.

  5. The list of fields and calculations that you compile during the second phase of the design process constitutes your organization's fundamental data requirements.

  6. You determine the various subjects that the tables will represent from the mission objectives you wrote during the first phase of the design process and ...

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.