4. Conceptual Overview

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


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 Defining Views

Reviewing Data Integrity


Review Questions

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, for you to have an overall idea of the way the database design process works and a general idea of the steps involved within ...

Get Database Design for Mere Mortals®: A Hands-on Guide to Relational Database Design, Third 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.