Chapter 4. Conceptual Overview

 

         I don't pretend to understand the Universe—               it's a great deal bigger than I am.       

 
 --Thomas Carlyle

Topics Covered in This Chapter

  • The Importance of Completing the Design Process

  • Defining a Mission Statement and Mission Objectives

  • Analyzing the Current Database

  • Creating the Data Structures

  • Determining and Establishing Table Relationships

  • Determining and Defining Business Rules

  • Determining and Establishing Views

  • Reviewing Data Integrity

  • Summary

Understanding how to design a relational database isn't quite as hard as understanding the universe; in fact, it's much easier. It is important, however, to have an overall idea of the way the database design process works and a general idea of the steps involved ...

Get Database Design for Mere Mortals 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.

Start your free trial