Relational Database Design with FileMaker Pro

with Cris Ippolite
please wait ...
Relational Database Design with FileMaker Pro
Video duration: 0s 2h 40m Intermediate Updated May 12, 2015

Viewers:

Let author Cris Ippolite show you how to translate aspects of the real world into the form and language of a relational database, using three practical data modeling examples. The course begins by reviewing some of the basic concepts of data modeling, introducing tables, key fields, and the Relationship Graph. Then, after demonstrating how to establish relationships in a database, the course concludes with a demonstration of some advanced modeling techniques, such as filtering, scripting, and the use of portals.

The course applies to versions of FileMaker Pro from 7 through the most current version.

Topics include:
  • Reviewing relationships types
  • Diagramming relationships
  • Resolving many-to-many relationships
  • Determining which tables need key fields
  • Defining tables in FileMaker Pro
  • Using the Relationship Graph
  • Using multiple match fields in one relationship
  • Using global fields to filter portals
  • Creating self relationships
  • Creating aggregate functions using relationships
Subjects:
Business IT
Software:
FileMaker Pro
Author:

Welcome

- Hi I'm Cris Ippolite and this is Relational Database Design for FileMaker Pro. In this course I'll discuss the concepts and techniques you can use to design a relational database in FileMaker. Using real world examples, I'll show you how to determine which tables you need to define in your relationship graph. As well as how and why to resolve those pesky many to many relationships. I'll explain how to use relationships in your scripts and calculations. And I'll also show you how to use portals, filtered portals, and related fields in your layouts.

And now it's time for us to dive into Relational Database Design with FileMaker Pro.

please wait ...