Chapter 5. Relational Database Design

In this chapter

Understanding Database Design

Database Analysis

Working with Entities and Attributes

Understanding Relationships

Relationship Optionality

Understanding the Role of Keys in Database Design

Many-to-Many Relationships: Solving the Puzzle

Normalizing Data: What Goes Where

The Basics of Process Analysis

FileMaker Extra: Complex Many-to-Many Relationships

Understanding Database Design

By now you’ve designed a simple FileMaker database and built some nice data-entry screens and some reports. Your friends and co-workers are clamoring for you to add features. Can your system do invoicing? Inventory tracking? Bar-coding?

Well, it can probably do all those things. But it’s going to take some planning. ...

Get Special Edition Using FileMaker 9 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.