Chapter 14. Creating Relational Databases
As you build databases, sooner or later you want to go relational, that is, to connect one database to another. Relational databases offer a way to make that connection—without slowing performance or requiring gigabytes of extra storage—by sharing data rather than duplicating it.
Instead of creating one big database packed with everything you might ever need to know about a subject, it makes far more sense to create a number of much smaller relational databases. Not only will relational databases help you focus on what’s key to each database—contacts in one database, products in another, invoices in still another—they take up far less space. All your product data, for example, stays in the product database. ...
Get FileMaker Pro 6 for Windows and MacIntosh: Visual QuickStart Guide 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.