Images

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

Reviewing Data Integrity

Summary

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 ...

Get Database Design for Mere Mortals: 25th Anniversary Edition, 4th 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.