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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.